The Slow Fade
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
We run a consumer app and want a cohort retention view: group users by the month they signed up, then for each following month measure the share of that cohort who logged at least one session. Report each cohort, the number of months after signup, and that active share.
Summary
They all arrive together. Watch the room empty, month by month.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision