Pro question

Day-7 retention by signup cohort

SQL & Data Modeling · Cohort Retention · hard · Original Uplift question · PostgreSQL · 18 min

For each signup date cohort, return the cohort size and the Day-7 retention rate: the share of users who were active exactly 7 days after signup.

This question is part of Pro

The prompt, fixtures, grading criteria and model write-up stay on the server until your plan unlocks them.

Source

Original Uplift question based on a common interview pattern.

Community

There is rarely one right query or one right framing. Read how others approached it, and share your own once you have submitted an answer.

Reading is open to everyone. Sign in to share your approach or mark a write-up as helpful.

Loading write-ups…