TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of

This challenge refers to a real-world problem I came across recently. The requirement was to identify all 'direct' or 'indirect' parents of a given child node and all its siblings.