foundation · sqlEditorial

NEW

How many users signed up each month

A cohort is everyone who signed up in the same month. Return cohort_month (text, YYYY-MM) and users — how many users are in that cohort — from cohort_users. Sort by cohort_month.

Tables & sample data

cohort_users

11 rows total · first 5 shown

user_idvarchar	signup_datedate
u_01	2026-01-05
u_02	2026-01-12
u_03	2026-01-20
u_04	2026-01-28
u_05	2026-02-03

query.sql

Loading editor…