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, "Physics": 20, "Chemistry": 10 } } |
| 2 | { "groups": { "CS": 6, "Physics": 8, "Chemistry": 5 } } |
| id | cs | physics | chemistry |
|---|---|---|---|
| 1 | 15 | 20 | 10 |
| 2 | 6 | 8 | 5 |