easy5 pts · first answer countssqljoins
Rows from an INNER JOIN
customers has 5 rows (ids 1 to 5). orders has 4 rows: two for customer 1, one for customer 2 and one for customer 3. How many rows does this query return?
SELECT c.name, o.amount FROM customers c JOIN orders o ON o.customer_id = c.id;