Loading interview...

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
senior

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.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision