🔮 Output PredictionSQ SQL Medium⚡+20 XP
LEFT JOIN Nulls
What happens to customers with no orders in this query?
SQL
SELECT c.name, o.total FROM customers c LEFT JOIN orders o ON c.id = o.customer_id;
What happens to customers with no orders in this query?
SELECT c.name, o.total FROM customers c LEFT JOIN orders o ON c.id = o.customer_id;