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 |