GROUP BY

GROUP BY — Groups rows that have the same values in specified columns into summary rows.

SELECT department, SUM(salary)
FROM employees
GROUP BY department;