SQL COUNT

Select job, deptno, COUNT(*) FROM EMP GROUP BY JOB, DEPTNO

MySQL:

Oracle:

PostgreSQL: