Correlated subqueries
SELECT d.name AS Department, e.name AS Employee, Salary\nFROM Employee e\nJOIN department d ON e.departmentId = d.id\nWHERE salary = (SELECT MAX(salary) FROM em
SELECT d.name AS Department, e.name AS Employee, Salary\nFROM Employee e\nJOIN department d ON e.departmentId = d.id\nWHERE salary = (SELECT MAX(salary) FROM employee WHERE departmentId = e.departmentId )\n\nI learned that from Mosh
['MySQL']