hardGCash · aggregationPro
Pivot payment channels into columns, per merchant
For each merchant, break down total transaction value by payment channel into separate columns: Wallet, GCredit, and Bank Transfer.
Return merchant, wallet_total, gcredit_total, and banktransfer_total.
Schema
▸transactions
| id | INT |
| merchant | TEXT |
| payment_channel | TEXT |
| amount | NUMERIC |
Pro
The example input, expected output, and walkthrough for this question unlock with a Pro plan.
Pro
This is a Pro question
Premium practice questions unlock with a Pro plan. The full solution, expected output, and grading are available to Pro members.