Does the top of the hierarchy show up?

Question

Accepted Answer

LEFT JOIN preserves all rows in the left table even when no match exists in the right copy. Alice has no manager (NULL manager_id), so the join produces NULL for m.name - she still appears in the result. Bob and Carol both resolve to Alice as their manager.