部门工资最高的员工
select d.name as Department, e.name as Employee, e.salary as Salary from Employee e left join Department d on e.departmentId = d.id where (e.departmentId, e.salary) in ( select departmentId, max(salary) from Employee group by departmentId )