Quarter-over-Quarter Latency Trend
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 SRE dashboard needs a quarter-over-quarter view of API latency from Q1 2023 through Q4 2025. For each quarter, show the average latency, the previous quarter's average, and the difference between them. If a quarter has no data, assume an average latency of 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