Intermediate · SQL · Joins

Employee with manager name (self join)

Commonly asked: Most common self-join question · ~8 min

Return employee and manager names for every employee (manager is NULL for those without one). Sort by employee.