Department Highest Salary

Find employees with the highest salary in each department by grouping employees by department, computing the max salary per group, and selecting all employees whose salary equals that max (including ties). Join with the Department table to return Department name, Employee name, and Salary.