A LEFT JOIN keeps every row from the customers table. Some customers match multiple rows in orders. How many rows does this query return if customer A has 3 orders and customer B has 0 orders?
SELECT c.name, o.id
FROM customers c
LEFT JOIN orders o ON c.id = o.customer_id;
-- only customers A and B exist