Return region, month, revenue and vs_month_avg = revenue − the average revenue of all regions in that month (rounded to 0).
18 rows with columns region, month, revenue, vs_month_avg — first 3 shown:
| # | ||||
|---|---|---|---|---|
| 1 | North | 2025-01-01 | 420000 | -13333 |
| 2 | North | 2025-02-01 | 455000 | 13333 |
| 3 | North | 2025-03-01 | 430000 | -6667 |
Run your code to see the output here.