Rank Employees by Salary

Rank all employees by salary within each department using RANK() window function. Return columns: salary, last_name, first_name, salary_rank, department_id. Order results by: salary DESC) AS salary_rank FROM employees ORDER BY department_id, salary_rank.