Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications

SELECT with AVG()

Q:13
Display average salary of Managers.


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

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