Power Users by Session Activity
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
- L3
Interview Prompt
Neither a pile of quick visits nor a couple of marathon sessions makes someone a power user: it takes at least 3 sessions that average at least 25 pages viewed each. List each power user's id, username, session count and total pages viewed, most total pages first.
Summary
More sessions. More time. The power users.
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