COURSE 13 OF 15
Hierarchical and Recursive Queries
Walk trees of any depth, build paths, and generate the rows you do not have, with one recursive CTE shape.
Builds on
Best read after 3. Joining Tables, 6. Strings and Text — you can still read ahead, but some of this may lean on ideas covered there.