What is the difference between WHERE and HAVING clauses?

WHERE:
• Filters rows before grouping
• Cannot use aggregate functions
• Applied to individual rows

HAVING:
• Filters groups after GROUP BY
• Can use aggregate functions
• Applied to grouped results

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