By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| time_stamp | product | plan_week | week_switch |
|---|---|---|---|
| 2020-01-01 | Product_A | CW01 | no |
| 2020-01-01 | Product_B | CW01 | yes |
| 2020-01-01 | Product_C | CW01 | yes |
| 2020-03-15 | Product_A | CW01 | no |
| 2020-03-15 | Product_B | CW02 | yes |
| 2020-03-15 | Product_C | CW02 | yes |
| 2020-03-15 | Product_D | CW01 | no |