Top-Performing Assets Query | Dataford Interview Questions

Write a query to extract the top-performing assets from this table.

Use valid, non-null closing values and consider only assets with at least two observations. Calculate each asset's total return from its earliest to latest valid observation, along with its average daily return. Return the top three assets.

Output

One row per selected asset with columns asset_id, asset_name, total_return_pct, average_daily_return_pct, and observation_count.
Include the three highest total returns, ordered descending, with asset_id ascending as the tie-breaker.

Schema

asset_prices

Column	Type	Description
asset_id	INT	Identifier for the asset
asset_name	VARCHAR(100)	Name of the asset
asset_class	VARCHAR(50)	Classification of the asset
observation_date	DATE	Date of the price observation
closing_value	NUMERIC(12,2)	Closing price or value for the asset on the observation date

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

Write a query to extract the top-performing assets from this table.

Output

One row per selected asset with columns asset_id, asset_name, total_return_pct, average_daily_return_pct, and observation_count.
Include the three highest total returns, ordered descending, with asset_id ascending as the tie-breaker.

Schema

asset_prices

Column	Type	Description
asset_id	INT	Identifier for the asset
asset_name	VARCHAR(100)	Name of the asset
asset_class	VARCHAR(50)	Classification of the asset
observation_date	DATE	Date of the price observation
closing_value	NUMERIC(12,2)	Closing price or value for the asset on the observation date

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