The Notification Lifecycle
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
Our push notification system records a delivery status for every message, but that status is entered inconsistently by the sending code. For each registered user, count how many of their notifications were delivered, how many were opened, and how many failed.
Summary
Sent, opened, ignored. What happened after the alert went out?
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