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

postgresql