For each region, return region, month, revenue, first_month_revenue and vs_first = revenue − first month's revenue.
18 rows with columns region, month, revenue, first_month_revenue, vs_first — first 3 shown:
| # | |||||
|---|---|---|---|---|---|
| 1 | South | 2025-01-01 | 380000 | 380000 | 0 |
| 2 | South | 2025-02-01 | 390000 | 380000 | 10000 |
| 3 | South | 2025-03-01 | 410000 | 380000 | 30000 |
Run your code to see the output here.