Busiest data center in each region
Capacity planning wants, for each region, the single data center with the highest usage percentage: the one closest to running out of headroom.
Return region, dc_name, and usage_pct.
Schema
▸datacenters
| id | INT |
| region | TEXT |
| dc_name | TEXT |
| usage_pct | NUMERIC |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime