Services at Median Uptime
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
The SRE team splits the fleet into four equal tiers by each service's average uptime across its health checks in `svc_health`, and wants the services that land in the two weakest tiers. For each one, their triage sheet needs that average, how far it sits below the fleet's most reliable service, and how far below the strongest service in its own tier.
Summary
Exactly at the median. Not above, not below.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision