What is the difference between WHERE and HAVING?

Answer preview

WHERE filters individual rows before grouping; HAVING filters groups after aggregation. That is why aggregate functions such as COUNT(*) or AVG(salary) are legal in HAVING but illegal in WHERE.…