avg_max_min_having1.htm
Query:

SELECT JOB, AVG(SAL) "AVG",
COUNT(*) "#NO" FROM EMP WHERE
JOB != 'PRESIDENT' GROUP BY JOB
HAVING AVG(SAL) < 2500
emp table:

 
Oracle:

PostgreSQL:
MySQL