GROUP BY

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

HAVING

SELECT department, COUNT(*) AS total 
FROM employees
GROUP BY department
HAVING total > 5;