The Weekly Pulse
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
The growth team wants the baseline notification cadence for untreated users: anyone placed in a control or holdout group of at least one experiment. For those users, give one row per day of the week, each with separate counts of ios, android, and web notifications plus how many unique users were reached that day.
Summary
Notifications by platform and day. When does the audience actually show up?
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