Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Anti-join: LEFT JOIN … IS NULL. To find rows with no match in another table, LEFT JOIN it and keep the rows where the joined table's key IS NULL. The LEFT JOIN keeps every row from the left side; the ones that found no partner get NULLs in the right table's columns, and the WHERE keeps only those.
select c.customer_name from customers c left join orders o on o.customer_id = c.customer_id where o.order_id is null
The warehouse lead wants to check that every Q4 order without a shipment record really was cancelled, and not forgotten on a shelf.
Return order_id, order_date and status for orders with an order_date on or after 2025-10-01 that have no row in shipments.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe