WHERE with OR operator in SQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all rows where the city is either 'New York' or 'Los Angeles'.

SQL

SELECT * FROM customers WHERE city [1] 'New York' OR city = 'Los Angeles';

Drag options to blanks, or click blank then click option'

A!=

B=

C<>

DLIKE

Attempts:

3 left

💡 Hint

Common Mistakes

Using '!=' or '<>' which check for inequality.

Using 'LIKE' without wildcards.

The = operator checks if the city matches 'New York'. Combined with OR, it selects rows where city is 'New York' or 'Los Angeles'.

2fill in blank

medium

Complete the code to select products where the category is 'Books' or the price is less than 20.

SQL

SELECT * FROM products WHERE category = 'Books' OR price [1] 20;

Drag options to blanks, or click blank then click option'

A>

B=

C<

D>=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' which selects prices greater than 20.

Using '=' which selects prices exactly 20.

The condition price < 20 selects products priced below 20. Combined with OR, it includes all books or any product cheaper than 20.

3fill in blank

hard

Fix the error in the query to select employees who work in 'HR' or have a salary greater than 50000.

SQL

SELECT * FROM employees WHERE department = 'HR' [1] salary > 50000;

Drag options to blanks, or click blank then click option'

AOR

BAND

CNOT

DXOR

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'AND' which restricts results to both conditions.

Using 'NOT' or 'XOR' which are not appropriate here.

The OR operator ensures the query selects employees in 'HR' or those with salary over 50000. Using AND would require both conditions to be true, which is not the goal.

4fill in blank

hard

Fill both blanks to select orders where the status is 'Pending' or the total is greater than 100.

SQL

SELECT * FROM orders WHERE status [1] 'Pending' [2] total > 100;

Drag options to blanks, or click blank then click option'

A=

B<

COR

DAND

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'AND' instead of 'OR' which restricts results.

Using '<' in the first blank which is incorrect for string comparison.

The first blank needs = to check if status equals 'Pending'. The second blank needs OR to select orders that meet either condition.

5fill in blank

hard

Fill all three blanks to select customers who live in 'Chicago' or 'Houston' and have made more than 5 orders.

SQL

SELECT * FROM customers WHERE (city = [1] [2] city = [3]) AND orders_count > 5;

Drag options to blanks, or click blank then click option'

A'Chicago'

B'Houston'

COR

DAND

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'AND' instead of 'OR' between city conditions.

Not using quotes around city names.

The query checks if city is 'Chicago' or 'Houston' using OR inside parentheses, then filters customers with more than 5 orders using AND.