Daily product turnover at the bank
Gazprombank builds a daily turnover mart for corporate products. Each operation is tied to a client (UUID), a product category (bank_product), and an amount in RUB.
Roll the data up to the product-plus-day grain: how many operations there were, the total amount, and the average amount rounded to two decimals.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| txn_cnt | txn_day | avg_amount | product_code | total_amount |
|---|---|---|---|---|
| 2 | 2024-04-01 | 4000.00 | CARD | 8000.00 |
| 2 | 2024-04-02 | 9250.00 | CARD | 18500.00 |
| 2 | 2024-04-03 | 5100.00 | CARD | 10200.00 |
Gazprombank
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid