Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Practice

1:	Determine the cost of tools per classification within gender. Subtotal the costs for each gender.
2:	Rank all employees by their total cost of eyeglasses and tool purchases. The employee with the lowest cost should be ranked first.
3:	Determine the two employees in each department who had the largest cost of eyeglasses purchases. Include employees who have not purchased eyeglasses.
4:	Create a checkbook-style cumulative cost of eyeglasses purchases.
5:	Compute the ratio of the total cost of each department’s eyeglasses purchases to the cost of all eyeglasses purchases.
6:	Determine whether the price of tools per tool is increasing. Use the LAG function to calculate the difference in the costs of each tool.
7:	Create a SELECT statement ...