The Slow Lane

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

Domain

SQL

Difficulty

medium

Seniority

mid

Problem

The reliability team is combing through server logs to find the machines that are dragging response times up. Give each server its average response time, then surface the ones sitting above the average machine, the mean of those per-server averages, slowest first.

Summary

One machine is dragging the fleet down. Find the ones running behind.

Practice This Problem

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