What is the difference between a HAVING clause with an aggregate and a WHERE clause for the same logical filter?

Question

SQL Fundamentals — Hard

What is the difference between a HAVING clause with an aggregate and a WHERE clause for the same logical filter?

Accepted Answer

The key difference between a HAVING clause with an aggregate and a WHERE clause is that WHERE cannot reference aggregate functions and filters individual rows before grouping, while HAVING filters groups after aggregation and can reference aggregates.