Your question is Merchant Volume Trends. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Mastercard analytics teams monitor transaction activity by Merchant Category Code, or MCC. Treat transaction volume as the number of settled transactions. Write a PostgreSQL query that summarizes daily activity for each matched merchant category.
merchant_categories using mcc_code.| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| mcc_code | INT | Mastercard Merchant Category Code |
| transaction_date | DATE | Settlement date |
| status | VARCHAR(20) | Transaction processing status |
| Column | Type | Description |
|---|---|---|
| mcc_codePK | INT | Mastercard Merchant Category Code |
| category_name | VARCHAR(100) | Human-readable merchant category |