Did Anyone Actually Read It?
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
Growth wants a clean read on push engagement for 2026. A notification only counts as a real win if it was actually delivered to the device (status = 'delivered', though the data is sloppy about capitalization) AND the user opened it (opened = 1). Among notifications sent during 2026, how many were both delivered and opened? Return a single column opened_count.
Summary
A push isn't a win until a thumb taps it.
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