Objective: having count order by
SELECT JOB,DEPTNO,COUNT(EMPNO) FROM EMP GROUP BY JOB, DEPTNO HAVING COUNT(*) >= 1 order by 3,2
Oracle
PostgreSQL
MySQL