SELECT with GROUP BY

Q:16
Display total salary paid in each Department.


SQL> SELECT DEPARTMENT, SUM(TOTAL) FROM EMPLOYEE GROUP BY DEPARTMENT;

DEPARTMENT                SUM(TOTAL)
------------------------- ----------
ACCOUNTS                       42000
FINANCE                        70000
IT                             84000
SALES                          49000