Simple MySQL Querry
\nSELECT \n    dep.Name as Department,\n    emp.Name as Employee,\n    emp.Salary \nfrom \n    Department dep,\n    Employee emp \nwhere \n    emp.DepartmentId 
```\nSELECT \n    dep.Name as Department,\n    emp.Name as Employee,\n    emp.Salary \nfrom \n    Department dep,\n    Employee emp \nwhere \n    emp.DepartmentId = dep.Id \nand \n    emp.Salary=\n        (Select \n            max(Salary) \n         from \n            Employee emp2 \n         where \n            emp2.DepartmentId=dep.Id)\n```\n\nPlease comment if there is any doubt in the above querry.\n\nPlease **Upvote** if you like the solution.
['MySQL']