I didn't take this problem along the iterative macro approach path, but I was able to create a solution by identifying where the level matched the parent id values. By using a few joins and multiplications and a final sort, the output followed the given solution!