Beyond the Signup
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
A month in which every session in `user_sessions` came from a different person shows no return visits, so the analyst tracking engagement drops it and keeps only months where someone logged more than one session. For each remaining month, report how many users were active and the average session duration.
Summary
Anyone can create an account. Fewer actually return.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision