SQL SCRIPT:

SELECT JOB, ROUND(AVG(SAL), 2) FROM emp where job != 'PRESIDENT' GROUP BY JOB

 
pOSTGFREsql:


Oracle :


Compare