By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
customerID | 1 | 2 | 3 | 4 |
---|---|---|---|---|
XXX | 2 | 1 | 1 | 1 |
YYY | 0 | 2 | 0 | 1 |
customerID | Status1 | Status2 | Status3 | Status4 |
---|---|---|---|---|
XXX | 2 | 1 | 1 | 1 |
YYY | 0 | 2 | 0 | 1 |