10 Lowest Uptime Services

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 is preparing a reliability review for the quarterly infrastructure meeting, and they want the 10 least reliable services from the health check records, judged by each service's lowest recorded uptime. Return each service's name with that lowest uptime.

Summary

Ten services at the bottom of the reliability chart.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write and run your SQL against a real database
4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision