Active Campaigns
An easy 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
- easy
- Seniority
- L3
Interview Prompt
The advertising team is reviewing campaign performance for the quarterly deck, and only campaigns that served more than 15 impressions make the cut. Show each of those campaigns with its impressions served, total revenue earned and click-through rate.
Summary
Which campaigns are earning their keep?
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