Second-Highest Server by Datacenter | Dataford Interview Questions

Write a SQL query to find the second-highest resource-consuming server from a telemetry log table, grouped by data center location.

Calculate each server's total resource consumption within its data center. Treat tied second-place totals as qualifying results, and ignore NULL resource values.

Output

One row per server tied for second place in its data center
Columns: data_center_location, server_id, total_resource_consumed
Order by data center location, then server ID

Schema

telemetry_logs

Column	Type	Description
telemetry_idPK	INT	Unique telemetry record identifier
server_id	VARCHAR(50)	Identifier of the monitored server
data_center_location	VARCHAR(100)	Data center where the server is located
resource_consumed	DECIMAL(12,2)	Resource units consumed in the telemetry interval
recorded_at	TIMESTAMP	Time when the telemetry was recorded

Your question is Second-Highest Server by Datacenter. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem