Grouping Data with GROUP BY in MySQL

GROUP BY Syntax

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

This groups employees by department and counts them.