quizmedium

WHERE vs HAVING?

Both filter rows, but HAVING runs first on the raw rowsWHERE filters rows before grouping and can't use aggregates; HAVING filters groups after GROUP BY and canWHERE filters groups after grouping; HAVING filters individual rows before itHAVING filters rows before grouping; WHERE filters the resulting groups