Objective :
SELECT job, round(AVG(sal),2)as avsal,COUNT(*) FROM EMP GROUP BY JOB
Oracle
postgresql