By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
lSn | id | mark_A | mark_B | real_group |
---|---|---|---|---|
1 | 10 | m_1 | m_2 | 1 |
2 | 17 | m_10 | m_11 | 3 |
3 | 18 | m_10 | m_8 | 3 |
4 | 19 | m_12 | m_13 | 4 |
5 | 20 | m_14 | m_15 | 5 |
6 | 21 | m_16 | m_17 | 6 |
7 | 11 | m_3 | m_4 | 2 |
8 | 12 | m_3 | m_5 | 2 |
9 | 13 | m_4 | m_3 | 2 |
10 | 14 | m_5 | m_6 | 2 |
11 | 15 | m_7 | m_3 | 2 |
12 | 16 | m_8 | m_9 | 3 |
id0 | idPathOrdered | calcGr |
---|---|---|
10 | 10 | 1 |
11 | 11,12,13,14,15 | 2 |
12 | 11,12,13,14,15 | 2 |
13 | 11,12,13,14,15 | 2 |
14 | 11,12,13,14,15 | 2 |
15 | 11,12,13,14,15 | 2 |
16 | 16,17,18 | 3 |
17 | 16,17,18 | 3 |
18 | 16,17,18 | 3 |
19 | 19 | 4 |
20 | 20 | 5 |
21 | 21 | 6 |