By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
FILE | ID | PARENTID | SHOWCHILD | CAT1 | CAT2 | CAT3 | TOTAL |
---|---|---|---|---|---|---|---|
F1 | A1 | P1 | N | 3 | 2 | 6 | 11 |
F2 | A2 | P2 | N | 4 | 7 | 3 | 14 |
F3 | A3 | P1 | N | 3 | 1 | 1 | 5 |
F4 | LG1 | null | Y | 6 | 3 | 6 | 16 |
F5 | LG2 | null | Y | 4 | 7 | 3 | 14 |
Tot | Res | Res | N | 10 | 10 | 9 | 30 |