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 building a clean user roster for outreach, but the 'admin' and 'system' accounts need to be excluded, as do users with a 'z' anywhere in their email address (a known test-account pattern). Return every remaining user's full profile, 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