By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 9 Duplicates: 0 Warnings: 0
| time_stamp | product | plan_week | quantity | week_switched | plan_week_switch | plan_week |
|---|---|---|---|---|---|---|
| 2020-01-01 | Product_A | CW01 | 125 | no | no | CW01 |
| 2020-03-15 | Product_A | CW01 | 570 | no | no | CW01 |
| 2020-01-01 | Product_B | CW01 | 300 | no | no | CW01 |
| 2020-01-01 | Product_C | CW01 | 700 | yes | CW01-to-CW02 | CW01 |
| 2020-03-15 | Product_C | CW02 | 150 | yes | CW01-to-CW02 | CW02 |
| 2020-01-01 | Product_D | CW01 | 900 | no | no | CW01 |
| 2020-03-15 | Product_E | CW02 | 325 | no | no | CW02 |
| 2020-01-01 | Product_G | CW01 | 600 | yes | CW01-to-CW05 | CW01 |
| 2020-03-15 | Product_G | CW05 | 482 | yes | CW01-to-CW05 | CW05 |