Objective

SELECT JOB,DEPTNO,COUNT(EMPNO) FROM EMP GROUP BY JOB, DEPTNO HAVING COUNT(*) >= 3

EMP table

Oracle

PostgreSQL

MySQL

 

l