-- Using Window Function to rank employees by salary within each department WITH RankedEmployees AS ( SELECT e.name AS employee_name, e.salary, d.name AS department_name, DENSE_RANK() OVER (PARTITION BY e.department_id ORDER BY e.salary DESC) as rank FROM Employees e JOIN Departments d ON e.department_id = d.id ) SELECT department_name, employee_name, salary FROM RankedEmployees WHERE rank <= 3 ORDER BY department_name, rank;