Customer Cohort Retention

Calculate how many customers from each acquisition month (cohort) placed orders in their first month. Return columns: cohort_month, cohort_size, first_month_orders, retention_rate. Order results by: c.cohort_month.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Calculate how many customers from each acquisition month (cohort) placed orders in their first month. Return columns: cohort_month, cohort_size, first_month_orders, retention_rate. Order results by: c.cohort_month.

Difficulty: Expert
SQL concept: CTE