Find Highest Salary In Each Department

Given two tables, employee and department, write a query to find the highest salary in each department. If multiple employees have the same highest salary, include all of them in the result. Implement this using a subquery. The follow-up is whether the result will differ if the subquery's JOIN is replaced with a LEFT JOIN. Example Input employee表和department表