Practice · medium · dataset: ecom
January buyers who skipped March
Find customers who placed at least one order in January 2026 but no order in March 2026. Return
customer_id and email, sorted by customer_id ascending.
Tables available
| Table | Columns |
|---|---|
customers |
customer_id, email, country, signup_date |
orders |
order_id, customer_id, order_date, status, channel |
January is 2026-01-01 up to but not including 2026-02-01; March is 2026-03-01 up to but not
including 2026-04-01. Order status does not matter.
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.