Best Day for Ad Revenue
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
- L5
Interview Prompt
We want to see how ad revenue lands across the days of the month in our impression log. Lay out each day of the month with its revenue per impression, its revenue per click and its biggest single-impression revenue.
Summary
Some days of the month convert far better than others.
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