For each month in monthly_sales, rank regions by revenue (1 = highest) as month_rank. Return month, region, revenue, month_rank.
18 rows with columns month, region, revenue, month_rank — first 3 shown:
| # | ||||
|---|---|---|---|---|
| 1 | 2025-05-01 | North | 560000 | 1 |
| 2 | 2025-05-01 | West | 530000 | 2 |
| 3 | 2025-05-01 | South | 470000 | 3 |
Run your code to see the output here.