Problem Statement

Create a recursive CTE to build the complete organizational hierarchy. Show employee name, their level in the organization, the full management path from CEO to employee, and total employees in their reporting chain (including sub-reports).

Relevant Tables