An analyst wants all customers listed, including those with no orders, while attaching matching order details when present. Which approach best fits?

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