By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
VK | PC | A | ORDER_A_PC | ORDER_PC |
---|---|---|---|---|
VK1 | PC1 | A1 | 1 | 1 |
VK2 | PC1 | A2 | 1 | 2 |
VK3 | PC2 | A1 | 1 | 1 |
VK4 | PC2 | A2 | 1 | 2 |
VK5 | PC1 | A2 | 2 | 3 |
VK6 | PC1 | null | null | null |
VK7 | PC2 | A2 | 2 | 3 |
VK8 | PC2 | null | null | null |