August 2002
Intermediate to advanced
528 pages
10h 12m
English
| 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 ... |