Problem Statement

For every employee, show their department, job title, and manager. INNER JOIN the dimension tables (departments, jobs) but LEFT JOIN to find the manager so top-level employees still appear. For top-level employees, label the manager 'Top Level'. Return employee_id, first_name, last_name, department_name, job_title, manager_label — ordered by department_id, employee_id.

Relevant Tables