Write a SQL query to identify the top five most active trading accounts based on monthly transaction volume.
Use the transaction amount as transaction volume. Return results for every month represented in the data, treating a month with no non-null amounts as zero volume.
transaction_month, account_id, account_name, transaction_count, monthly_transaction_volume, and monthly_rank| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique trading account identifier |
| account_name | VARCHAR(100) | Display name of the trading account |
| account_type | VARCHAR(30) | Classification of the trading account |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| account_id | INT | Trading account that executed the transaction |
| transaction_timestamp | TIMESTAMP | Timestamp when the transaction occurred |
| transaction_volume | DECIMAL(14,2) | Monetary transaction volume |
| transaction_type | VARCHAR(20) | Type of trading transaction |