SQL COUNT
Select job, deptno, COUNT(*) FROM EMP GROUP BY JOB, DEPTNO
MySQL:
Oracle:
PostgreSQL: