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.