Using AdventureWorks, for example, I want to get a list of all employees and their managers, with the managers having the most subordinates at the top. Easy enough to get the number of reports each manager has by using a GROUP BY, but I want the actual list of their subordinates, on separate rows.Using AdventureWorks, for example, I want to ge