Group Rows with the Same Value

GROUP BY separates rows that share a value. SELECT city, COUNT(*) FROM customers GROUP BY city calculates one count per city and returns one row per group. NULL forms a group too.