Problem Statement

Assign a unique row number to every employee ordered by salary descending (ties broken by employee_id). Return first_name, last_name, salary, department_name, row_num — ordered by row_num.

Relevant Tables