Cashfree needs a monthly transaction report for its merchants. Write a SQL query to return the number of transactions recorded for each merchant during the previous calendar month, using September 15, 2026 as the reporting reference date.
merchant_id, merchant_name, and transaction_count.transaction_count descending, then merchant_id ascending.| Column | Type | Description |
|---|---|---|
| merchant_idPK | VARCHAR(20) | Unique Cashfree merchant identifier |
| merchant_name | VARCHAR(150) | Registered merchant name |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | BIGINT | Unique transaction identifier |
| merchant_id | VARCHAR(20) | Merchant associated with the transaction |
| transaction_at | TIMESTAMP | Timestamp when the transaction was created |