By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| STORE_ID | TRAN_DATE | YEAR | PERIOD_NO | ORDERS | SALES | ORDERS_PTD | SALES_PTD |
|---|---|---|---|---|---|---|---|
| 10 | 01-JAN-19 | 2019 | 1 | 10 | 119.12 | 10 | 119.12 |
| 10 | 02-JAN-19 | 2019 | 1 | 15 | 201.56 | 25 | 320.68 |
| 10 | 03-JAN-19 | 2019 | 1 | 13 | 167.92 | 38 | 488.6 |