SELECT stage, COUNT(*) AS n FROM deals GROUP BY stage gives one row per stage. Every column in SELECT must be either grouped or aggregated. HAVING filters after grouping (HAVING COUNT(*) > 10); WHERE filters rows before grouping.