Loading interview...

First-Day Session Retention

A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
SQL
Difficulty
hard
Seniority
mid, senior

Interview Prompt

A user is 'retained' if they have a session exactly 1 calendar day after their very first session. Calculate the proportion of retained users out of all users. Return a single retention rate.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision