Employee With Manager Name

Problem

Self-join `employees(id, name, manager_id)` to return each employee with their manager's name. CEOs (NULL manager_id) should appear with manager 'N/A'.

Input

employees(id, name, manager_id)

Output

name, manager_name

Constraints

1 ≤ rows ≤ 10^4

Sample input

(1,'Sundar',NULL),(2,'Ada',1),(3,'Linus',1),(4,'Grace',2)

Sample output

Sundar | N/A
Ada    | Sundar
Linus  | Sundar
Grace  | Ada

Explanation

Self-join: same table aliased twice, joined by manager_id → id.

joinsself-joincoalesce@Microsoft

Visible test cases

in: see prompt

out: rows

Your solution — run it, use AI if stuck

sql

Solution & hidden tests are Pro-only — upgrade

All problems Back to courses