Testing Script :

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

Postgresql;

Oracle