Top Clients by Volume Last 30 Days | Dataford Interview Questions

Write a query to find the top 5 clients by total transaction volume in the last 30 days, including their total asset value.

Use the provided client, transaction, and asset tables. Treat the last 30 days relative to CURRENT_DATE; clients without a matching asset record should still be eligible.

Output

One row per qualifying client with client_id, client_name, total_transaction_volume, and total_asset_value
Include the five highest transaction volumes, ordered descending, with client_id ascending as the tie-breaker

Schema

clients

Column	Type	Description
client_idPK	INT	Unique client identifier
client_name	VARCHAR(100)	Client display name

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
client_id	INT	Client associated with the transaction
transaction_date	DATE	Date the transaction occurred
transaction_amount	NUMERIC(14,2)	Transaction amount

client_assets

Column	Type	Description
asset_record_idPK	INT	Unique asset record identifier
client_id	INT	Client who owns the assets
asset_value	NUMERIC(16,2)	Value represented by the asset record

Your question is Top Clients by Volume Last 30 Days. 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