Practice · easy · dataset: ecom
Pending orders in the first quarter
Support is working through the order queue and wants every order that is still pending from the first quarter of 2026 — January 1 through March 31, inclusive.
Return four columns: order_id, order_date, channel, and nothing else. Include only orders
whose status is pending. Sort by order_date ascending and break ties by order_id ascending.
Tables available
| Table | Columns |
|---|---|
orders |
order_id, customer_id, order_date, status, channel |
Statuses other than pending (paid, shipped, cancelled, refunded) must not appear in the
result, even when they fall inside the quarter.
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.