WEEKLY ENGINEERING PRACTICE
Where did the unmatched rows go?
A small reasoning exercise. Follow the behavior, choose an explanation and use the feedback to decide what to practice next.
Trace the behavior
Which customers remain? Assume there are some customers with no matching order.
SELECT c.name, o.total
FROM customers AS c
LEFT JOIN orders AS o ON c.id = o.customer_id
WHERE o.total >= 50;