w3resource

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

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) 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.

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