回复：请教SQL高手一个问题,先谢了

Select e1.Department, count (e1.id) as “number of employees”
From Employees e1
inner join employees e2 on e1.manager_id=e2.id
Where e1.Salary > e2.salary
Group by e1.Department