An analyst needs the most recent order for each customer while keeping its associated columns. Which approach best fits?

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