Return region, month, revenue and pct_of_region — that month's share of the region's 6-month total (2 decimals).
18 rows with columns region, month, revenue, pct_of_region — first 3 shown:
| # | ||||
|---|---|---|---|---|
| 1 | North | 2025-01-01 | 420000 | 14.41 |
| 2 | North | 2025-02-01 | 455000 | 15.61 |
| 3 | North | 2025-03-01 | 430000 | 14.75 |
Run your code to see the output here.