Problem Statement

Build a per-employee report combining INNER JOINs (department, job) with a LEFT JOIN (manager), plus a CASE-based performance_tier from salary vs job range: 'High Performer' (salary >= max_salary * 0.8), 'Good Performer' (salary >= min_salary * 1.2), 'Standard Performer' otherwise. Return employee_id, first_name, last_name, department_name, location, job_title, salary, min_salary, max_salary, manager_id, hire_date, performance_tier — ordered by employee_id.

Relevant Tables