Top Regions by High CPU Nodes

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

Domain

SQL

Difficulty

hard

Seniority

L5

Problem

Capacity planning wants to know which regions have the most overloaded nodes. Return the top 5 regions by count of nodes running above 90% CPU. If regions are tied, they share the same rank without gaps. Include all regions within the top 5 ranks with their high-CPU node count.

Summary

Five regions with the hottest CPUs.

Practice This Problem

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