SQL Exercises

Intermediate SQL WHERE Clause Exercises

0 Exercises
~0 min

Intermediate-level SQL WHERE Clause practice exercises with solutions.

Exercise 1

Question: Find employees who are NOT in the Engineering or Marketing departments.

SELECT * FROM employees WHERE department NOT IN ('Engineering', 'Marketing');

NOT IN excludes specified values. This is cleaner than writing multiple AND conditions.

Related Content

Continue Learning

exerciseMySQL: Intermediate SQL WHERE Clause Exercises
exercisePostgreSQL: Intermediate SQL WHERE Clause Exercises
exerciseSQL Server: Intermediate SQL WHERE Clause Exercises
exerciseSQL WHERE Clause Exercises for Beginners
exerciseSQL WHERE Clause Exercises (With Answers)

From Our Blog

The Filter: Mastering the WHERE ClauseThe Old Way: JOIN in the WHERE ClauseFiltering Groups: HAVING vs. WHERE

Ready for more practice?

Join SQL Mastery and get access to interactive exercises, quizzes, and more.