10 Lowest Uptime Services

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The SRE team is preparing a reliability review for the quarterly infrastructure meeting. Each service has multiple health check records, and the team needs to surface the 10 worst-performing services based on their lowest recorded uptime. If multiple services are tied at the 10th position, include all of them. Return the service name and its lowest uptime value.

Summary

Ten services at the bottom of the reliability chart.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.