By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| CHILD | ROOT | RN |
|---|---|---|
| AA | A | 1 |
| AB | A | 2 |
| AAA | A | 3 |
| BB | B | 1 |
| BBB | B | 2 |
| BBBA | B | 3 |
| BBBB | B | 4 |
| C1 | C | 1 |
| C2 | C | 2 |
| C3 | C | 3 |
| C4 | C | 4 |
| C5 | C | 5 |
| C6 | C | 6 |
| C7 | C | 7 |
| C8 | C | 8 |
| CHILD | ROOT | RN |
|---|---|---|
| AA | A | 1 |
| AB | A | 2 |
| AAA | A | 3 |
| BB | B | 1 |
| BBB | B | 2 |
| BBBA | B | 3 |
| BBBB | B | 4 |
| C1 | C | 1 |
| C2 | C | 2 |
| C3 | C | 3 |
| C4 | C | 4 |
| C5 | C | 5 |
| C6 | C | 6 |
| C7 | C | 7 |
| C8 | C | 8 |