What does HAVING filter?

Question

Accepted Answer

SQL executes WHERE before GROUP BY, so WHERE can only see raw column values - not aggregate results. HAVING runs after GROUP BY, so it can filter on things like HAVING COUNT(*) > 5 or HAVING SUM(amount) > 1000. A common mistake is writing WHERE COUNT(*) > 5, which fails because COUNT is not yet computed at that stage.