User Session 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
Produce a complete user-to-session roster that includes users who have never started a session. Show each user's name, account status, signup date, and session start time, by username and then session start.
Summary
Every user paired with their sessions, even users who never logged in
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