Problem Statement

Build a per-employee profile combining INNER JOINs for required dimensions (department, job) and a LEFT JOIN for the optional manager. Return employee_id, first_name, last_name, department_name, location, job_title, salary, min_salary, max_salary, manager_first_name, manager_last_name, hire_date — ordered by employee_id.

Relevant Tables