SQLite Exercise: Display the names and salary for all employees whose salary is not in the specified range and are in department 30 or 100

Write a query to display the names (first_name, last_name) and salary for all employees whose salary is not in the range $10,000 through $15,000 and are in department 30 or 100.

Sample table : employees

SQLite Code :

SELECT first_name, last_name, salary, department_id
FROM employees
WHERE salary NOT BETWEEN 10000 AND 15000 
AND department_id IN (30, 100);

Output:

first_name  last_name   salary      department_id
----------  ----------  ----------  -------------
Daniel      Faviet      9000        100
John        Chen        8200        100
Ismael      Sciarra     7700        100
Jose Manue  Urman       7800        100
Luis        Popp        6900        100
Alexander   Khoo        3100        30
Shelli      Baida       2900        30
Sigal       Tobias      2800        30
Guy         Himuro      2600        30
Karen       Colmenares  2500        30

Relational Algebra Expression:

Relational Algebra Tree:

Practice SQLite Online

Model Database

Structure of 'hr' database :

Improve this sample solution and post your code through Disqus.

Previous: Write a query to display the names (first_name, last_name) and department ID of all employees in departments 30 or 100 in ascending alphabetical order by department ID.
Next: Write a query to display the first_name of all employees who have both an "b" and "c" in their first name.