1. What is the difference between WHERE and HAVING?
EasySQL
Technical
Show model answer
WHERE filters individual rows before grouping; HAVING filters groups after GROUP BY and can use aggregates.
Example: `SELECT customer_id, SUM(amount) FROM orders WHERE status = 'paid' GROUP BY customer_id HAVING SUM(amount) > 500;`