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.