Practice · medium · dataset: ecom
Signups by day of week
Count customer signups by ISO day of week, where Monday is 1 and Sunday is 7.
Return day_of_week and signup_count. Sort by day_of_week ascending.
Tables available
| Table | Columns |
|---|---|
customers |
customer_id, email, country, signup_date |
Use the signup date, not the order date. Every day that has at least one signup should appear once.
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.