Problem Statement

List every employee with the name of their direct manager. Top-level employees (manager_id IS NULL) must still appear — show NULL for manager_first_name and manager_last_name. Return employee_id, first_name, last_name, manager_id, manager_first_name, manager_last_name — ordered by employee_id.

Relevant Tables