DAY 1丨部门工资最高的员工【难度中等】

SELECT b.name AS Department,a.name  AS Employee ,a.salary AS Salary
FROM employee a LEFT JOIN department b ON a.DepartmentId=b.Id
GROUP BY a.name
ORDER BY salary DESC
LIMIT 2;
 

mark