Sign-ups per Month

easy
Unit 1 · Aggregation & Joins I0/3 to milestone

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