Practice · easy · dataset: ecom
Monthly order volume
Finance wants monthly order volume for every month represented in the dataset. Return month (the
first day of the month) and order_count, sorted by month ascending.
Tables available
| Table | Columns |
|---|---|
orders |
order_id, customer_id, order_date, status, channel |
Use the order date, not the signup date. One row per month is enough; there is no need to fill in months with no orders.
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.