Understand where WHERE and HAVING belong when joining and aggregating tables.
You want each customer's total from orders placed in 2023, but only customers whose total exceeds 1000. Which query is correct?
Schema: customers(id, name), orders(id, customer_id, amount, order_date)