Under the Same Name

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

Service agents record a status for every health check, but different agents write the same state in different letter casing, so 'Healthy' and 'healthy' both land in the table as separate labels. Report the average check latency for each health status, treating casing differences as the same state, with the slowest states listed first.

Summary

The same state wears different casing. Read the latency behind each one.

Practice This Problem

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