Cohort Retention Rate With CTEs
Hard
ctes
Netflix
Spotify
Airbnb
Calculate month-1 retention: for each signup cohort month, count users who also made a purchase in the following month. Return cohort_month, signed_up, retained, and retention_rate (rounded to 2 decimal places as a fraction 0–1), ordered by cohort_month.
Expected Output: Cohort month with signup count, retained count, and rate.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...