-- SQL recursive CTE to find subordinates of executive, manager & supervisor-- Tree processing - find all descendants - find…