Quarters Apart
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
The reliability team reports API latency to leadership one quarter at a time and wants to see how each quarter compares to the one before it. For the three calendar years before 2026, show every quarter in order with its average latency, the previous quarter's average, and the difference between them; if a quarter has no calls, treat its average as 120.0.
Summary
Latency trending up or down? The quarters have the answer.
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