For South, return month, revenue and prev_revenue (the previous month's revenue).
6 rows with columns month, revenue, prev_revenue — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | 2025-01-01 | 380000 | NULL |
| 2 | 2025-02-01 | 390000 | 380000 |
| 3 | 2025-03-01 | 410000 | 390000 |
Run your code to see the output here.