CEO Subordinate Hierarchy
SQL teaching model. Walk the reporting tree down from the CEO with a recursive query, give each person a level, and count everyone who reports to them directly or indirectly.
SQL teaching model. Walk the reporting tree down from the CEO with a recursive query, give each person a level, and count everyone who reports to them directly or indirectly.