Problem Statement

For every employee, show their direct manager and their skip-level manager (the manager's manager). Use TWO LEFT JOINs back to employees. Top-level employees show NULL for both manager fields. Return employee_id, first_name, last_name, direct_manager_first_name, direct_manager_last_name, skip_level_first_name, skip_level_last_name — ordered by employee_id.

Relevant Tables