Filtered User Roster
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
The growth team is assembling a clean outreach roster and wants the 'admin' and 'system' accounts left out, along with anyone whose email carries a 'z' anywhere (a known test-account marker). Keep every other user, including those who have no email on record yet, and return each remaining profile in full, alphabetical by username.
Summary
A clean roster for the all-hands.
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