Top-Performing Assets Query | Dataford Interview Questions

Write a query to identify the top-performing assets over the last three quarters.

Use assets and asset_quarterly_performance. Define performance as the sum of valid quarterly returns, and include only assets with valid results for all three quarters.

Output

Return the top three performance ranks, including ties.
Include asset_id, asset_name, total_return, quarters_reported, and performance_rank.
Order by rank ascending, then asset ID ascending.

Schema

assets

Column	Type	Description
asset_idPK	INT	Unique asset identifier
asset_name	VARCHAR(100)	Asset display name
asset_class	VARCHAR(50)	Investment asset classification

asset_quarterly_performance

Column	Type	Description
performance_idPK	INT	Unique performance record identifier
asset_id	INT	Referenced asset identifier
quarter_end	DATE	Quarter-ending date
quarterly_return	DECIMAL(8,4)	Asset return for the quarter

Your question is Top-Performing Assets Query. 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