The following data definition defines an organisation's employee hierarchy. An employee is a manager if he or she has his or her manager ID set to the original employee (i.e. manager) ID.
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.
- Example case: Wrong answer
- No managers: Wrong answer
- Workers have managers: Wrong answer
- Managers have managers: Wrong answer