Problem Statement

For every employee, compute their salary, the department's average salary (rounded 2), and a label: 'Above Average' / 'Below Average' / 'Average'. Return employee_id, first_name, last_name, department_name, salary, avg_salary, salary_comparison — ordered by department_id, salary DESC, employee_id.

Relevant Tables