SQLite Exercise: Find the names of the employees who are managers

Write a query to find the names (first_name, last_name) of the employees who are managers.

Sample table : employees

SQLite Code:

SELECT first_name, last_name 
FROM employees 
WHERE (employee_id IN (SELECT manager_id FROM employees));


first_name  last_name
----------  ----------
Steven      King
Neena       Kochhar
Lex         De Haan
Alexander   Hunold
Nancy       Greenberg
Den         Raphaely
Matthew     Weiss
Adam        Fripp
Payam       Kaufling
Shanta      Vollman
Kevin       Mourgos
John        Russell
Karen       Partners
Alberto     Errazuriz
Gerald      Cambrault
Eleni       Zlotkey
Michael     Hartstein
Shelley     Higgins

Practice SQLite Online

Model Database

Employee Model  Database - w3resource online SQLite practice

Structure of 'hr' database :

hr database

Improve this sample solution and post your code through Disqus.

Previous: Write a query to find the names (first_name, last_name) of the employees who have a manager who works for a department based in the United States.
Next: Write a query to find the names (first_name, last_name), the salary of the employees whose salary is greater than the average salary.

What is the difficulty level of this exercise?

Follow us on Facebook and Twitter for latest update.

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook