Node Utilization

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

Domain

SQL

Difficulty

hard

Seniority

L4

Problem

The capacity planning team is hunting for overloaded nodes against their regional baseline. In infra_nodes, compute the average cpu_pct per region (skipping NULL cpu_pct), then find nodes whose cpu_pct exceeds their own region's average. Within each region rank those nodes sorted from highest cpu_pct to lowest with ties sharing a position. Return the hostname, region, cpu_pct, regional average, and position.

Summary

Overloaded nodes hiding in busy regions. Spot the hot spots.

Practice This Problem

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