Return on a Glance
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
The marketing analytics team is benchmarking how much revenue each ad campaign earns per impression, where every impression served counts toward the average even the ones that brought in nothing. Give each campaign that figure, highest first.
Summary
Every impression costs something. Find the campaigns earning it back.
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