easyTouch 'n Go · window
Show every top-up next to the overall average
Support wants to eyeball whether a top-up is unusually large, so every row should carry the average top-up amount alongside it.
Return topup_id, amount, and avg_amount — the average amount across all top-ups, rounded to 2 decimal places. Every row shows the same avg_amount. Order by topup_id.
Schema
▸topups
| topup_id | INT |
| wallet_id | TEXT |
| amount | NUMERIC |
Example input
▸topups
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.