Analytics Reporting Track · Hard · 35 min
Power Usage Outliers
Infrastructure wants to flag racks with unusual power spikes. Return rack_id, usage_date, kilowatt_hours, and the rack_average rounded to two decimals for ro...
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a Google-tagged business scenario.
Approach
Use this track to train on SQL that mirrors day-to-day analytics workflows and recurring reporting asks.
Company context
Company labels are directional practice context, not official interview guidance.
Infrastructure wants to flag racks with unusual power spikes. Return rack_id, usage_date, kilowatt_hours, and the rack_average rounded to two decimals for rows where kilowatt_hours is more than 150 percent of that rack's average usage. Sort by rack_id, then usage_date.
daily_power_usage
| rack_id | usage_date | kilowatt_hours | 2 |
|---|---|---|---|
| 1 | 2024-06-01 | 110.00 | |
| 1 | 2024-06-02 | 115.00 | |
| 1 | 2024-06-03 | 210.00 | |
| 2 | 2024-06-01 | 80.00 | |
| 2 | 2024-06-02 | 82.00 | |
| 2 | 2024-06-03 | 85.00 | |
| 3 | 2024-06-01 | 60.00 | |
| 3 | 2024-06-02 | 140.00 | |
| 3 | 2024-06-03 | 65.00 |
SQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.