Top 3 Assets Per Sector | Dataford Interview Questions

Write a query to find the top 3 performing assets per sector for each month, given a table of daily returns.

Treat an asset's monthly performance as the sum of its non-null daily returns. Return available results when a sector and month contain fewer than three assets.

Output

One row per ranked asset, with month, sector, asset_id, monthly_return, and performance_rank.
Include only the top three assets per sector and month, ranking higher monthly returns first and breaking ties by asset_id ascending.
Order by month, sector, and performance_rank.

Schema

daily_returns

Column	Type	Description
return_idPK	INT	Unique identifier for the daily return record
asset_id	VARCHAR(20)	Identifier of the traded asset
sector	VARCHAR(50)	Sector classification for the asset
return_date	DATE	Date associated with the daily return
daily_return	DECIMAL(10,6)	Daily return expressed as a decimal

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