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
- L4
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.
Summary
Ghost accounts. Active signup, zero sessions.
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