SQLite Exercise: Find the names of all employees who works in the IT department

Write a query to find the names (first_name, last_name) of all employees who works in the IT department.

Sample table : employees

SQLite Code:

SELECT first_name, last_name 
FROM employees 
WHERE department_id 
IN (SELECT department_id FROM departments WHERE depart_name='IT');

Output:

first_name  last_name
----------  ----------
Alexander   Hunold
Bruce       Ernst
David       Austin
Valli       Pataballa
Diana       Lorentz

Practice SQLite Online

Model Database

Structure of 'hr' database :

Improve this sample solution and post your code through Disqus.

Previous: Write a query to find the names (first_name, last_name) and salaries of the employees who have a higher salary than the employee whose last_name='Bull'.
Next: 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.