How many rows does this LEFT JOIN return?

-- customers: 1, 2, 3 (3 rows) -- orders: customer_id = 1 (twice), customer_id = 1 (once) -- => 3 order rows, all for customer 1 SELECT * FROM customers c LEFT JOIN orders o ON c.id = o.customer_id;