Skip to content
RED SAGSkills
easy5 pts · first answer countssqljoins

Rows returned by a LEFT JOIN

How many rows does this query return?

-- users:  (1, 'Ana'), (2, 'Bo'), (3, 'Cy')
-- orders: (10, user_id = 1), (11, user_id = 1), (12, user_id = 3)

SELECT u.name, o.id
FROM users u
LEFT JOIN orders o ON o.user_id = u.id;
Choose one answer