Generate a report of salary totals by department, the result might look something like the report that follows.
SELECT dept_no, SUM(salary) FROM employee GROUP BY dept_no;
The result might be similar to the report that follows.
dept_no
------- |
SUM(salary)
----------- |
---|---|
100 | 180,500.00 |
300 | 143,000.00 |
500 | 268,000.00 |
600 | 146,600.00 |
700 | 113,000.00 |