easy · ~8 min
HR needs an org directory listing every employee in employees alongside their direct manager's name.
employees
manager_id
manager_name
emp_id
employee_name
Input contract: emp_id is unique and non-null in employees; name is non-null. manager_id is nullable (NULL when an employee has no manager) and otherwise references an emp_id in employees.
name