Use GROUP BY with ORDER BY to find top values
We're thinking about running a geo-targeted campaign. Can you show me which states have the most customers? Just the top 5 would be great — state and count.
Each hint you reveal reduces the XP you can earn. Try the query first.
Group customers by `state` using `GROUP BY state`, then count each group with `COUNT(*)`
Sort by count descending with `ORDER BY ... DESC` and use `LIMIT 5` to get only the top 5 states
Alias your count column as `customer_count`: `COUNT(*) AS customer_count`