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

Domain

SQL

Difficulty

medium

Seniority

L4

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.

Summary

Reliability tiers. Based on uptime.

Practice This Problem

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