Monthly Signups with Date Truncation
Easy
date-functions
Airbnb
Stripe
Spotify
Given a users table with a signup_date column, write a query that counts how many users signed up in each calendar month. Return one row per month with the month (formatted YYYY-MM) and the signup count, ordered chronologically.
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...