SQL: What is the difference between HAVING and WHERE? Can WHERE be replaced with HAVING?

Question

Accepted Answer

HAVING is used with GROUP BY to filter grouped rows, WHERE is used to filter individual rows. WHERE cannot be replaced with HAVING.

WHERE is used to filter individual rows before grouping, HAVING is used to filter grouped rows after grouping
HAVING is used in conjunction with GROUP BY clause, WHERE is used independently
WHERE filters rows based on conditions, HAVING filters groups based on conditions
Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000