Write a query to find the top-performing real estate agents based on monthly transaction volume, handling ties appropriately.
Use the transaction date to determine the month and count transactions for each agent. Return only agents tied for the highest volume in their month.
transaction_month, agent_id, agent_name, transaction_volume, and performance_rank| Column | Type | Description |
|---|---|---|
| agent_idPK | INT | Unique real estate agent identifier |
| agent_name | VARCHAR(100) | Agent's display name |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| agent_id | INT | Agent responsible for the transaction |
| transaction_date | DATE | Date on which the transaction occurred |