Self-join in SQL Server: each person and their manager

The manager’s name lives in the same table. You join Staff to Staff and give each side an alias so SQL Server can tell them apart.

Staff with manager name

SELECT e.first_name AS staff,
       e.team,
       m.first_name AS manager
FROM Staff e
LEFT JOIN Staff m ON m.staff_id = e.manager_id
ORDER BY e.first_name;

LEFT JOIN so the person at the top (no manager) still appears. INNER JOIN would hide them.