Missing Email for Non-Active Users
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
A downstream notification pipeline is failing for a subset of users. You traced the issue to users from 2026 who have no email on file but whose account is not active. Find those user IDs.
Summary
No email on file. No recent activity. Something smells off.
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