Top Assets Per Sector SQL | Dataford Interview Questions

Write a SQL query to find the top 3 performing assets in each sector over the last quarter.

Use the provided sector, asset, and performance data. Treat an asset's performance as the sum of its recorded returns during the previous calendar quarter. Exclude assets without a matching sector or performance record.

Output

One row per selected asset, with sector_name, asset_id, asset_name, quarterly_return_pct, and performance_rank.
Include up to three assets per sector, ordered by return descending, with asset_id as the tie-breaker.

Schema

sectors

Column	Type	Description
sector_idPK	INT	Unique sector identifier
sector_name	VARCHAR(100)	Sector name

assets

Column	Type	Description
asset_idPK	INT	Unique asset identifier
asset_name	VARCHAR(150)	Asset name
sector_id	INT	Associated sector identifier

asset_performance

Column	Type	Description
performance_idPK	INT	Unique performance record identifier
asset_id	INT	Asset identifier
performance_date	DATE	Date of the recorded return
return_pct	DECIMAL(8,4)	Return percentage for the record

Your question is Top Assets Per Sector SQL. 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