Top Assets by Region in 30 Days | Dataford Interview Questions

An operations team wants to identify the strongest-performing assets in each region. Write a SQL query to calculate each asset's total performance score over the trailing 30 calendar days ending on September 15, 2026, and return the top three assets per region.

Output

One row per qualifying asset, with columns region, asset_id, asset_name, total_performance, and performance_rank.
Include only performance records from September 15, 2026, and the preceding 29 calendar days. Ignore NULL performance scores when calculating totals.
Return no more than three assets per region. Order by region, performance rank, and asset ID. Break ties by smaller asset ID.

Schema

assets

Column	Type	Description
asset_idPK	INT	Unique identifier for the asset
region	VARCHAR(50)	Operational region assigned to the asset
asset_name	VARCHAR(100)	Display name of the asset

asset_performance

Column	Type	Description
performance_idPK	INT	Unique identifier for a performance record
asset_id	INT	Asset associated with the performance record
recorded_at	DATE	Date on which performance was recorded
performance_score	DECIMAL(10,2)	Performance score recorded for the asset

Your question is Top Assets by Region in 30 Days. Start with the requirements and the two 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