42. GROUP BY Statement SQL
Use GROUP BY statement to group rows that have the same values into summary rows, like "find the number of customers in each department". GROUP BY statement is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG).