Simple solution using WHERE and AND
\nSELECT D.NAME AS Department, E.NAME AS Employee, E.SALARY AS Salary\nFROM EMPLOYEE AS E, DEPARTMENT AS D\nWHERE D.ID = E.DEPARTMENTID\nAND E.SALARY = \n    (S
```\nSELECT D.NAME AS Department, E.NAME AS Employee, E.SALARY AS Salary\nFROM EMPLOYEE AS E, DEPARTMENT AS D\nWHERE D.ID = E.DEPARTMENTID\nAND E.SALARY = \n    (SELECT MAX(SALARY) \n     FROM EMPLOYEE AS E2 \n     WHERE E2.DEPARTMENTID = D.ID)\n```\n\n\n
[]