By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 11
| parent | node | color |
|---|---|---|
| AB | ABD | green |
| AC | ACG | red |
| AC | ACF | gray |
| A | AC | gray |
| A | AB | green |
| null | A | gray |
| ABD | ABDE | green |
| ACF | ACFH | red |
| ACF | ACFI | green |
| ACG | ACGJ | red |
| ACG | ACGK | red |
SELECT 11