Problem Statement

What RANK() OVER PARTITION BY Department Produces What does the following query return for an Employees table? SELECT EmployeeID, Department, Salary, RANK() OVER ( PARTITION BY Department ORDER BY Salary DESC ) AS SalaryRank FROM Employees;