Chaining two self joins up the hierarchy

Question

Accepted Answer

The query chains two self joins to walk two levels up the hierarchy. The first join finds each employee's direct manager. The second join finds that manager's manager. Carol's manager is Bob; Bob's manager is Alice. So Carol's grand-manager is Alice. Bob has a manager (Alice) but Alice has no manager, so Bob's row produces no match in the second join and is excluded.