SQL Exercises

SQL Server: Intermediate SQL WHERE Clause Exercises

0 Exercises

~0 min

This guide is specifically for SQL Server syntax.

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.

SQL Server-Specific Notes

This page covers SQL Server syntax. Other databases may have different syntax for similar operations.

Related Content

Continue Learning

exerciseSQL Server: SQL WHERE Clause Exercises for Beginners

exerciseSQL Server: SQL WHERE Clause Exercises (With Answers)

exerciseMySQL: Intermediate SQL WHERE Clause Exercises

exercisePostgreSQL: Intermediate SQL WHERE Clause Exercises

exerciseIntermediate SQL WHERE Clause Exercises

From Our Blog

The Filter: Mastering the WHERE Clause The Old Way: JOIN in the WHERE Clause Filtering Groups: HAVING vs. WHERE

Ready for more practice?

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