Practice · easy · dataset: ecom
Orders needing follow-up
Support is triaging orders that still need attention. Return order_id, status, channel, and
order_date for every order placed through the web or mobile channel whose status is not
paid.
Sort by order_date ascending, then by order_id ascending.
Tables available
| Table | Columns |
|---|---|
orders |
order_id, customer_id, order_date, status, channel |
Orders can be pending, paid, shipped, cancelled, or refunded. The request only excludes
paid; every other status belongs in the result.
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.