Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
EXCEPT. EXCEPT returns the rows of the first query that are missing from the second: A EXCEPT B means 'in A but not in B'. The order matters, because B EXCEPT A is a different list. Duplicates are removed.
select category from products except select category from products where list_price > 30
Account managers want the customers who completed orders early in 2025 but had no completed order at all in the last quarter, so they can call them before the new year.
Return customer_name for customers with a completed order between 2025-01-01 and 2025-03-31 and no completed order between 2025-10-01 and 2025-12-31.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe