Node Utilization

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

Domain

SQL

Difficulty

hard

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.

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.