Loading interview...

Latency Quartiles Per Endpoint

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
mid, senior

Interview Prompt

For the API performance review, divide each endpoint's calls into four equal-sized buckets by latency, then for each endpoint-bucket pair show the minimum latency, maximum latency, and average latency. Results should appear ordered by endpoint name, then by bucket number.

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