Testing Script :
SELECT JOB, ROUND(AVG(SAL), 2) FROM emp where job = 'SALESMAN' GROUP BY JOB
Postgresql;
Oracle