w3resource

SQLite Exercise: Find the names, the salary of the employees who earn more than the average salary and who works in any of the IT departments

Write a query to find the names (first_name, last_name), the salary of the employees who earn more than the average salary and who works in any of the IT departments.

Sample table : employees


Sample table : departments


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

Output:

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 whose salary is equal to the minimum salary for their job grade.
Next: Write a query to find the names (first_name, last_name), the salary of the employees who earn more than Mr. Bell.

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