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 |
| 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 |