Problem Statement

For each employee compute their salary rank (1 = highest) by counting how many distinct higher salaries exist. Ties share a rank. Return employee_id, first_name, last_name, salary, salary_rank — ordered by salary_rank, employee_id.

Relevant Tables