WHERE vs HAVING

• WHERE → filters rows before grouping.
• HAVING → filters groups after aggregation.

SELECT department, COUNT(*) 
FROM Employees 
WHERE salary > 50000
GROUP BY department
HAVING COUNT(*) > 5;