Left on Read
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 flags whether each notification was opened and records the campaign that sent it. Across the campaigns that have sent notifications, find the ones whose opens beat the average campaign's opens.
Summary
Every campaign fights for the tap. Find the ones the field is leaving behind.
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