Problem Statement

For each employee, classify whether their salary is within / below / above their job's configured range. The JOIN itself is plain equality on job_id; the inequality lives in the CASE expression. Return employee_id, first_name, last_name, salary, job_title, min_salary, max_salary, salary_status — ordered by salary DESC, employee_id.

Relevant Tables