SQLite Exercise: Find the names of the employees who are not supervisors

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

Sample table: employees

SQLite Code:

SELECT first_name, last_name, salary 
FROM employees 
WHERE department_id IN 
(SELECT department_id FROM departments WHERE depart_name LIKE 'IT%') 
AND salary > (SELECT avg(salary) FROM employees);


first_name  last_name   salary
----------  ----------  ----------
Alexander   Hunold      9000

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), the salary of the employees who earn the same salary as the minimum salary for all departments.
Next: Write a query to display the employee ID, first name, last names, salary of all employees whose salary is above average for their departments.

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