By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Id | Entity | Parent |
---|---|---|
1 | A | null |
2 | AA | A |
3 | AB | A |
4 | ABA | AB |
5 | ABB | AB |
6 | AAA | AA |
7 | AAB | AA |
8 | AAC | AA |
Entity | Count |
---|---|
A | 2 |
AA | 3 |
AB | 2 |
ABA | 0 |
ABB | 0 |
AAA | 0 |
AAB | 0 |
AAC | 0 |