How to solve: Find Highest Salary in Each Department?

Question

Accepted Answer

To find the highest earner per department:
1. Aggregate the max salary per department with `SELECT departmentId, MAX(salary) FROM Employee GROUP BY departmentId`.
2. Filter the outer `Employee` rows where the `(departmentId, salary)` tuple matches that subquery.
3. Join with `Department` to output clean department names.