Top Five Users by Volume | Dataford Interview Questions

Write a SQL query to find the top five users by transaction volume on Binance. Calculate each user's total volume across all transaction records and treat missing volume values as zero.

Output

One row per user, with user_id, username, and total_volume
Include the five users with the highest total volume
Order by total_volume descending, then user_id ascending to break ties

Schema

users

Column	Type	Description
user_idPK	INT	Unique Binance user identifier
username	VARCHAR(100)	Binance username
country_code	VARCHAR(2)	Two-letter user country code

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
user_id	INT	User responsible for the transaction
volume_usdt	NUMERIC(20,2)	Transaction volume denominated in USDT
transaction_date	DATE	Date on which the transaction occurred

Your question is Top Five Users by 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