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);
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
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.
What is the difficulty level of this exercise?
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join