Practice · medium · dataset: ecom
Monthly activity reconciliation
Reconcile monthly signups and monthly orders into one table. Return month (the first day of the
month), signup_count, and order_count, using 0 when a month appears in only one source.
Include every month from 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 months and order months do not overlap in this dataset, so each row will have a zero in one of the two count columns.
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.