By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| UserNo | StoreNo | ProductNo | Order | StoreOrder |
|---|---|---|---|---|
| 001 | S01 | P01 | 1 | 1 |
| 001 | S01 | P02 | 2 | 1 |
| 001 | S02 | P02 | 3 | 2 |
| 001 | S02 | P03 | 4 | 2 |
| 001 | S02 | P04 | 5 | 2 |
| 001 | S01 | P05 | 6 | 3 |
| 001 | S01 | P06 | 7 | 3 |
| 001 | S01 | P07 | 8 | 3 |
| 002 | S01 | P08 | 1 | 1 |
| 002 | S02 | P09 | 2 | 2 |
| 003 | S01 | P01 | 1 | 1 |
| 003 | S02 | P01 | 2 | 2 |
| 003 | S02 | P02 | 3 | 2 |