Skip to content
RED SAGSkills
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;
Choose one answer