Loading interview...

Monthly Service 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
senior

Interview Prompt

For December 2025 and January 2026, find the percentage of users active in a given month who also appear in any future month. Treat missing future activity as zero retention. Return the service name, month, and retention percentage.

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