Loading...
Service Reliability Tiers
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid, senior
Problem
Classify services by uptime into reliability tiers: 99.9%+ is 'Platinum', 99.0 to 99.89% is 'Gold', 95.0 to 98.99% is 'Silver', below 95% is 'Bronze'. For each tier, show the minimum, average, and maximum latency. Exclude any checks where the status mentions 'maintenance'. Results should go from highest average latency to lowest.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.