Your question is Aggregate by Category and Date. Start with the requirements and the one table 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.
Synechron's Analytics Platform team tracks daily revenue across service categories. Write a PostgreSQL query that summarizes this activity by category and transaction date.
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| category | VARCHAR(50) | Synechron service category |
| transaction_date | DATE | Date of the transaction |
| revenue | DECIMAL(12,2) | Transaction revenue, which may be NULL |