By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
11 rows affected
ID | A | B | C | X |
---|---|---|---|---|
1 | A1 | B3 | C1 | 1 |
2 | A1 | B2 | C5 | 1 |
3 | A1 | B10 | C10 | 1 |
4 | A2 | B1 | C5 | 1 |
5 | A2 | B8 | C1 | 1 |
6 | A3 | B1 | C4 | 1 |
7 | A4 | B6 | C3 | 1 |
8 | A4 | B3 | C5 | 1 |
9 | A5 | B7 | C2 | 2 |
10 | A6 | B10 | C3 | 1 |
11 | A8 | B5 | C4 | 1 |