Practice · medium · dataset: ecom
Monthly signups and orders
Build one monthly activity table that combines customer signups and orders. Return month (the
first day of the month), signup_count, and order_count.
Use 0 in the column that has no activity for a month, and include every month that appears in either
source. Sort by month ascending.
Tables available
| Table | Columns |
|---|---|
customers |
customer_id, email, country, signup_date |
orders |
order_id, customer_id, order_date, status, channel |
Signup dates and order dates cover different calendar years; the combined table should still be ordered by month across both ranges.
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.