Top Assets by Transaction Volume | Dataford Interview Questions

Write a query to identify top-performing assets based on transaction volume over a specific period in DTCC transaction data.

For this exercise, use the period from January 1, 2025 through March 31, 2025, inclusive. Return the three highest transaction-volume ranks, including all assets tied at the third rank.

Output

One row per qualifying asset with asset_id, asset_name, transaction_volume, and performance_rank
Include only transactions within the period and order by rank ascending, then asset_id ascending

Schema

assets

Column	Type	Description
asset_idPK	INT	Unique identifier for the asset
asset_name	VARCHAR(100)	Display name of the asset
asset_type	VARCHAR(40)	Asset classification

transactions

Column	Type	Description
transaction_idPK	INT	Unique identifier for the transaction
asset_id	INT	Referenced asset identifier
transaction_date	DATE	Date the transaction was recorded
transaction_type	VARCHAR(30)	Transaction classification

Your question is Top Assets by Transaction Volume. 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