Sign-ups per Month

easy
Checkpoint challenge
Solve this to show you know the material and jump straight to Unit 2. Everything before it counts as cleared.

How fast is the customer base growing? Return month (YYYY-MM, from signup_date) and signups (the number of customers who signed up that month), sorted by month.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#aggregation#dates1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Sign-ups per Month · TechGradify