My SQL code as follows, any ideas why it's not working???
SELECT d1.Name AS Department, e1.Name AS Employee, Salary FROM Department d1 JOIN Employee e1 ON d1.Id=e1.DepartmentId GROUP BY d1.Id HAVING Max(Salary)