SQL Exercises

SQL WHERE Clause Exercises (With Answers)

20 Exercises
~100 min
16 Beginner4 Intermediate

Exercise 1

beginner

Question

Select all employees with a salary greater than 50000.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  salary DECIMAL(10,2)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE salary > 50000;

Expected Output

| id | name | salary |
|---|---|---|
| 2 | Jane | 60000 |
| 3 | Alice | 75000 |

Explanation

The WHERE clause filters rows based on a condition. Comparison operators include: =, <>, <, >, <=, >=

Exercise 1

beginner

Question

Select all employees with a salary greater than 50000.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  salary DECIMAL(10,2)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE salary > 50000;

Expected Output

| id | name | salary |
|---|---|---|
| 2 | Jane | 60000 |
| 3 | Alice | 75000 |

Explanation

The WHERE clause filters rows based on a condition. Comparison operators include: =, <>, <, >, <=, >=

Exercise 1

beginner

Question

Select all employees with a salary greater than 50000.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  salary DECIMAL(10,2)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE salary > 50000;

Expected Output

| id | name | salary |
|---|---|---|
| 2 | Jane | 60000 |
| 3 | Alice | 75000 |

Explanation

The WHERE clause filters rows based on a condition. Comparison operators include: =, <>, <, >, <=, >=

Exercise 1

beginner

Question

Select all employees with a salary greater than 50000.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  salary DECIMAL(10,2)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE salary > 50000;

Expected Output

| id | name | salary |
|---|---|---|
| 2 | Jane | 60000 |
| 3 | Alice | 75000 |

Explanation

The WHERE clause filters rows based on a condition. Comparison operators include: =, <>, <, >, <=, >=

Exercise 2

beginner

Question

Find employees in the 'Sales' department with salary between 40000 and 60000.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  salary DECIMAL(10,2),
  department VARCHAR(50)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE department = 'Sales' AND salary BETWEEN 40000 AND 60000;

Expected Output

| id | name | salary | department |
|---|---|---|---|
| 1 | John | 50000 | Sales |

Explanation

Use AND to combine multiple conditions. BETWEEN is inclusive of both endpoints.

Exercise 2

beginner

Question

Find employees in the 'Sales' department with salary between 40000 and 60000.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  salary DECIMAL(10,2),
  department VARCHAR(50)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE department = 'Sales' AND salary BETWEEN 40000 AND 60000;

Expected Output

| id | name | salary | department |
|---|---|---|---|
| 1 | John | 50000 | Sales |

Explanation

Use AND to combine multiple conditions. BETWEEN is inclusive of both endpoints.

Exercise 2

beginner

Question

Find employees in the 'Sales' department with salary between 40000 and 60000.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  salary DECIMAL(10,2),
  department VARCHAR(50)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE department = 'Sales' AND salary BETWEEN 40000 AND 60000;

Expected Output

| id | name | salary | department |
|---|---|---|---|
| 1 | John | 50000 | Sales |

Explanation

Use AND to combine multiple conditions. BETWEEN is inclusive of both endpoints.

Exercise 2

beginner

Question

Find employees in the 'Sales' department with salary between 40000 and 60000.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  salary DECIMAL(10,2),
  department VARCHAR(50)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE department = 'Sales' AND salary BETWEEN 40000 AND 60000;

Expected Output

| id | name | salary | department |
|---|---|---|---|
| 1 | John | 50000 | Sales |

Explanation

Use AND to combine multiple conditions. BETWEEN is inclusive of both endpoints.

Exercise 3

beginner

Question

Select employees whose names start with 'J'.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE name LIKE 'J%';

Expected Output

| id | name |
|---|---|
| 1 | John |
| 2 | Jane |

Explanation

LIKE with % wildcard matches any sequence of characters. 'J%' matches strings starting with J.

Exercise 3

beginner

Question

Select employees whose names start with 'J'.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE name LIKE 'J%';

Expected Output

| id | name |
|---|---|
| 1 | John |
| 2 | Jane |

Explanation

LIKE with % wildcard matches any sequence of characters. 'J%' matches strings starting with J.

Exercise 3

beginner

Question

Select employees whose names start with 'J'.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE name LIKE 'J%';

Expected Output

| id | name |
|---|---|
| 1 | John |
| 2 | Jane |

Explanation

LIKE with % wildcard matches any sequence of characters. 'J%' matches strings starting with J.

Exercise 3

beginner

Question

Select employees whose names start with 'J'.

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100)
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE name LIKE 'J%';

Expected Output

| id | name |
|---|---|
| 1 | John |
| 2 | Jane |

Explanation

LIKE with % wildcard matches any sequence of characters. 'J%' matches strings starting with J.

Exercise 4

intermediate

Question

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

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  department VARCHAR(50)
);
Show Solution

Solution

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

Expected Output

| id | name | department |
|---|---|---|
| 1 | John | Sales |
| 4 | Mike | HR |

Explanation

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

Exercise 4

intermediate

Question

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

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  department VARCHAR(50)
);
Show Solution

Solution

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

Expected Output

| id | name | department |
|---|---|---|
| 1 | John | Sales |
| 4 | Mike | HR |

Explanation

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

Exercise 4

intermediate

Question

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

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  department VARCHAR(50)
);
Show Solution

Solution

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

Expected Output

| id | name | department |
|---|---|---|
| 1 | John | Sales |
| 4 | Mike | HR |

Explanation

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

Exercise 4

intermediate

Question

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

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  department VARCHAR(50)
);
Show Solution

Solution

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

Expected Output

| id | name | department |
|---|---|---|
| 1 | John | Sales |
| 4 | Mike | HR |

Explanation

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

Exercise 5

beginner

Question

Select employees where the manager_id is NULL (no manager assigned).

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  manager_id INT
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE manager_id IS NULL;

Expected Output

| id | name | manager_id |
|---|---|---|
| 1 | CEO John | NULL |

Explanation

Use IS NULL to check for NULL values. Using = NULL will not work because NULL represents unknown values.

Exercise 5

beginner

Question

Select employees where the manager_id is NULL (no manager assigned).

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  manager_id INT
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE manager_id IS NULL;

Expected Output

| id | name | manager_id |
|---|---|---|
| 1 | CEO John | NULL |

Explanation

Use IS NULL to check for NULL values. Using = NULL will not work because NULL represents unknown values.

Exercise 5

beginner

Question

Select employees where the manager_id is NULL (no manager assigned).

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  manager_id INT
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE manager_id IS NULL;

Expected Output

| id | name | manager_id |
|---|---|---|
| 1 | CEO John | NULL |

Explanation

Use IS NULL to check for NULL values. Using = NULL will not work because NULL represents unknown values.

Exercise 5

beginner

Question

Select employees where the manager_id is NULL (no manager assigned).

Table Schema

SQL
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  manager_id INT
);
Show Solution

Solution

SQL
1SELECT * FROM employees WHERE manager_id IS NULL;

Expected Output

| id | name | manager_id |
|---|---|---|
| 1 | CEO John | NULL |

Explanation

Use IS NULL to check for NULL values. Using = NULL will not work because NULL represents unknown values.

Related Content

Continue Learning

exerciseSQL Server: SQL WHERE Clause Exercises (With Answers)
exerciseMySQL: SQL WHERE Clause Exercises (With Answers)
exercisePostgreSQL: SQL WHERE Clause Exercises (With Answers)
exerciseMySQL: SQL HAVING Clause Exercises (With Answers)
exerciseSQL HAVING 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.