Loading interview...

Inactive Users in Date Range

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
mid

Interview Prompt

The data quality team flagged stale records in a dimension table. Identify users who had zero sessions between June 1 and July 1, 2026. Include both users who were active outside that window and users who never had any sessions at all.

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