Oracle Interview Question

Technical one: SQL hierarchical query.