Return region, month, revenue and region_total (that region's six-month total on every row).
18 rows with columns region, month, revenue, region_total — first 3 shown:
| # | ||||
|---|---|---|---|---|
| 1 | North | 2025-01-01 | 420000 | 2915000 |
| 2 | North | 2025-02-01 | 455000 | 2915000 |
| 3 | North | 2025-03-01 | 430000 | 2915000 |
Run your code to see the output here.