SELECT with AVG()

Q:13
Display average salary of Managers.


SQL> SELECT AVG(TOTAL) FROM EMPLOYEE WHERE DESIGNATION='MANAGER';

AVG(TOTAL)
----------
     52500