Practice · easy · dataset: ecom
Orders per channel
The operations team wants a channel breakdown of order volume. For each channel, count the orders
placed and return two columns: channel and order_count.
Sort by order_count descending, then by channel ascending.
Tables available
| Table | Columns |
|---|---|
orders |
order_id, customer_id, order_date, status, channel |
Every order has exactly one channel, so no order should be counted twice.
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.