A query must filter aggregated groups to regions whose total sales exceed a threshold. Which approach best fits?

1. Use HAVING for the aggregate condition.
2. Use a LEFT JOIN from customers to orders.
3. Use a window ranking function and retain the first row per customer.
4. Use GROUP BY region with SUM of the sales amount.