Best Day for Ad Revenue
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
The ad team wants to see which calendar days carry the strongest click premium: the gap between average revenue on clicked impressions and on non-clicked ones. Break the numbers down by day of the month (1 through 31), and for each day report the overall average revenue, the biggest single-impression revenue, and that click premium, widest premium first.
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 your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision