text: # Write your MySQL query statement below
  select dep.Name as Department, emp.Name as Employee, emp.Salary
  from Department dep, Employee emp 
  where emp.DepartmentId=dep.Id 
  and emp.Salary=(Select max(Salary) from Employee e2 where e2.DepartmentId=dep.Id)