Intra-Region Latency Diff
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
Each row in svc_health is a single health check, and the monitor logs status in mixed case ('Healthy', 'healthy', 'DEGRADED' and so on) where every spelling is treated as its own condition, so only checks marked exactly 'healthy' qualify. Within a region, pair every qualifying check with every other healthy check whose uptime reading sits within 5 percentage points of it, counting pairs between two different checks even when they belong to the same service. For each service (svc_name), report the average absolute latency gap across all the pairs its checks take part in.
Summary
Same region. Different latency.
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