The Weekly Pulse
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
The growth team wants a notification volume breakdown for users who are enrolled in at least one experiment, pivoted by platform and day of week. Give one row per day of the week with separate counts of ios, android, and web notifications sent.
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 your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision