Log Levels

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

Domain

SQL

Difficulty

easy

Problem

The SRE team is building a performance digest for the weekly incident review. For each log severity level, they want to know the number of entries and the average response time in milliseconds. Only include severity levels that have generated at least five log entries, and list them from the slowest average response time to the fastest.

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.