List every employee with their manager's name (self-join with NULL handling).

Answer preview

Use a LEFT JOIN back to employees so that people with no manager are kept instead of being filtered out by an inner join.…