Losing Altitude
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 ad campaigns lost momentum between June and October of 2026. Within each of those two months, campaigns are placed by how many of their impressions were clicked, most first; surface the campaigns that sat lower in October than they did in June.
Summary
Two months apart, the same campaigns. Find the ones that slipped.
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