Campaign Engagement Rank Shift
A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L5
Interview Prompt
A stakeholder flagged that some campaigns lost momentum between June 2025 and October 2025. Rank each campaign by the number of impressions where clicked is 1 in each of those two months, then surface just the campaign names whose ranking position worsened (higher rank number) from June to October.
Summary
Two months, many countries. Who moved up? Who fell?
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