For each order in 2024, return order_id, order_date, order_value and month_to_date — cumulative order value within the same month (by date, then order_id).
25 rows with columns order_id, order_date, order_value, month_to_date — first 3 shown:
| # | ||||
|---|---|---|---|---|
| 1 | 1020 | 2024-09-08 | 4999 | 4999 |
| 2 | 1025 | 2024-12-15 | 4999 | 4999 |
| 3 | 1021 | 2024-10-02 | 3997 | 3997 |
Run your code to see the output here.