User 360
A hard 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
- hard
- Seniority
- L6
Interview Prompt
The product team wants a one-row-per-user activity summary that covers every user. For each user, show how many transactions they made, the total amount they spent, and their total time on site, and alongside each user include the platform-wide average spend per user.
Summary
One row per user. Everything they did, or didn't do.
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