By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| CALENDAR_DATE | CUSTOMER_ID | AMOUNT | ROLLING_SUM |
|---|---|---|---|
| 01-JAN-21 | 20211003 | 59 | 59 |
| 27-JAN-21 | 20211003 | 25 | 84 |
| 25-FEB-21 | 20211003 | 188 | 272 |
| 28-AUG-21 | 20211003 | 90 | 90 |
| 01-JAN-21 | 20211005 | 100 | 100 |
| 23-MAR-21 | 20211005 | 67 | 167 |
| 24-APR-21 | 20211009 | 43 | 43 |
| 11-JUL-21 | 20211009 | 65 | 108 |
| 25-MAY-21 | 20211013 | 21 | 21 |
| 26-MAY-21 | 20211013 | 89 | 110 |