By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 2 Duplicates: 0 Warnings: 0
id | jdoc |
---|---|
1 | { "groups": { "CS": 15, "History": 10, "Physics": 20 } } |
2 | { "groups": { "CS": 6, "Physics": 8, "Chemistry": 5 } } |
id | Chemistry | CS | History | Physics |
---|---|---|---|---|
1 | null | 15 | 10 | 20 |
2 | 5 | 6 | null | 8 |