Top Identified Event Types
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
We're analyzing an event stream where every record carries an event type and, when the user was logged in, their user_id. Surface the three most common event types, keeping only the types logged more often by identified users than by anonymous ones, and return each type with its total event count.
Summary
The top users by events, but only the identifiable ones.
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