Response Buckets

A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain

SQL

Difficulty

medium

Seniority

L5

Interview Prompt

The performance team wants API calls bucketed by latency. For each row in api_calls with a non-NULL latency, label it 'fast' when latency is under 100, 'normal' when latency is between 100 and 500 inclusive, and 'slow' when latency is above 500. Return the endpoint, latency, and that label.

Summary

Fast, normal, or slow. Every API call gets a verdict.

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