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.
user_id, username, and total_volumetotal_volume descending, then user_id ascending to break ties| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique Binance user identifier |
| username | VARCHAR(100) | Binance username |
| country_code | VARCHAR(2) | Two-letter user country code |
| 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 |