Employees Without a Manager

In the employees table, manager_id holds the emp_id of the person each employee reports to. Top-level people have a NULL manager_id.

List the employees who have no manager.

Return columns emp_id, name. Row order does not matter.

Schema

CREATE TABLE employees (
  emp_id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  manager_id INTEGER
);

Sample data

employees

Hint 1

Comparing with = NULL is never true. Use IS NULL.

Hint 2

A manager_id of 0 is a value, not a missing manager.

SQL (SQLite)

Run checks your query on the sample data (Ctrl + '). Submit also checks hidden databases.