Present a Kaggle-like data analysis.
Using the supplied transaction and merchant data, identify the top two merchants by monthly completed transaction value during the first quarter of 2025. Exclude declined transactions, unmatched merchants, and merchants whose monthly completed value is below 100.
month, merchant_id, merchant_name, transaction_count, total_amount, and monthly_rank.month ascending, monthly_rank ascending, and merchant_id ascending.| Column | Type | Description |
|---|---|---|
| merchant_idPK | INT | Unique merchant identifier |
| merchant_name | VARCHAR(100) | Merchant display name |
| region | VARCHAR(50) | Merchant operating region |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| merchant_id | INT | Merchant associated with the transaction |
| transaction_date | DATE | Transaction processing date |
| status | VARCHAR(20) | Transaction processing status |
| amount | NUMERIC(12,2) | Transaction amount |