SQL GROUP BY

SQL

Usage

SELECT department, COUNT(*) FROM employees GROUP BY department

Sources