By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| period | customer_no | date | product |
|---|---|---|---|
| 1 | 111 | 2017-01-01 | X |
| 2 | 111 | 2017-05-09 | Y |
| 3 | 111 | 2017-05-09 | Y |
| 4 | 111 | 2018-02-05 | Z |
| 5 | 111 | 2018-02-05 | Z |
| 6 | 111 | 2018-02-05 | Z |
| 7 | 111 | 2018-02-05 | Z |
| 8 | 111 | 2018-02-05 | Z |
| 6 | 222 | 2017-02-02 | X |
| 7 | 222 | 2017-06-04 | Z |
| 8 | 222 | 2017-06-04 | Z |
| 9 | 222 | 2017-06-04 | Z |
| 10 | 222 | 2018-05-09 | B |
| 11 | 222 | 2018-05-09 | B |
| 12 | 222 | 2018-05-09 | B |
| 13 | 222 | 2019-02-01 | A |
| 14 | 222 | 2019-02-01 | A |
| 15 | 222 | 2019-02-01 | A |