Workers


SQL Subqueries Public

Hard  

7min

The following data definition defines an organization's employee hierarchy. An employee is a manager if any other employee has it's managerId set to the first employees id. An employee who is a manager may or may not also have a manager.

TABLE employees
  id INTEGER NOT NULL PRIMARY KEY
  managerId INTEGER REFERENCES employees(id)
  name VARCHAR(30) NOT NULL

Write a query that selects the names of employees who are not managers.

See the example case for more details.

SQLite 3.19.3
   

  •   Example case: Wrong answer
  •   No managers: Wrong answer
  •   Workers have managers: Wrong answer
  •   Managers have managers: Wrong answer