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;
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;