Average Node CPU by Region

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

Domain

SQL

Difficulty

easy

Seniority

junior

Problem

Capacity planning is evaluating whether to add nodes in specific regions, but they only care about regions that are actually running workloads. Using the pod assignment records, show the average CPU utilization of nodes in each region where at least one pod has been scheduled.

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.