Code AnalysisIntermediate 45s

LEFT JOIN vs INNER

Given users (1,2,3) and orders (user 1 has 2 orders, user 2 has none), how many rows from LEFT JOIN?

Starter code

SELECT * FROM users LEFT JOIN orders ON users.id = orders.user_id;

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.