Choosing the right combination of joins, aggregation, and subqueries to answer an analytical question.
You have customers(id, name) and orders(id, customer_id, amount). You want each customer's name and total spend, but only for customers whose total spend exceeds the average total spend across all customers. Which approach is correct?