SELECT with SUM()

Q:12
Display the Total salary paid to salesmen.


SQL> SELECT SUM(TOTAL) FROM EMPLOYEE WHERE DESIGNATION='SALESMAN';

SUM(TOTAL)
----------
     14000