No Dead Months
A hard 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
- hard
- Seniority
- L4
Interview Prompt
We're auditing ad campaigns for dead months, calendar months where a campaign got no clicks at all. List every campaign that had one, along with the revenue from its single heaviest month.
Summary
Every month it ran, it landed a click. Among those, find the ones whose worst month of spend stayed lowest.
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