Retention & Cohorts SQL interview questions
Product and growth interviews love retention. Assign users to cohorts, measure activity relative to each user's start date and keep non-retained users in the denominator.
- 90-Day Repeat Rate by First-Order CohortRetention & Cohorts · Subqueries & CTEshard
- New vs Returning Riders by MonthRetention & Cohorts · Subqueries & CTEshard
- Weekly Signup Cohort RetentionRetention & Cohorts · Dates & Timehard