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

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