Top Servers Per Region | Dataford Interview Questions

Write a SQL query using window functions to find the top three highest traffic-generating servers per region at Akamai.

Use the provided region, server, and traffic tables. Calculate each server's total traffic across its traffic records, exclude servers with no positive traffic, and assign a deterministic rank for ties.

Output

One row per qualifying server, with region_name, server_id, server_name, total_traffic_bytes, and traffic_rank.
Include only the top three servers in each region.
Order by region_name, then traffic_rank, then server_id.

Schema

regions

Column	Type	Description
region_idPK	INT	Unique region identifier
region_name	VARCHAR(100)	Akamai service region name

servers

Column	Type	Description
server_idPK	INT	Unique server identifier
server_name	VARCHAR(100)	Server hostname
region_id	INT	Region assigned to the server

traffic_logs

Column	Type	Description
traffic_log_idPK	INT	Unique traffic record identifier
server_id	INT	Server associated with the traffic record
traffic_bytes	BIGINT	Bytes served in the traffic record

Your question is Top Servers Per Region. Start with the requirements and the three tables 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