Problem Statement

For each employee compute: their department's median salary, the difference from it, and their percentile rank within the department (PERCENT_RANK × 100, rounded to 2). Return department_name, first_name, last_name, salary, dept_median, diff_from_median, percentile_rank — ordered by department_name, salary DESC, employee_id.

Relevant Tables