SQL Filtering with WHERE Clause 3

Question 1

Which query finds products priced 100 or less OR with quantity above 50?

Accepted Answer

WHERE price <= 100 OR quantity > 50

Answer

OR returns rows satisfying at least one of the two conditions exactly as written.

Question 2

What is the result of WHERE quantity NOT IN (1, 2, 3)?

Accepted Answer

Rows where quantity is none of 1, 2, or 3

Answer

NOT IN excludes rows matching any value in the list.

Question 3

Which condition matches strings containing 'sql' anywhere in the column?

Accepted Answer

LIKE '%sql%'

Answer

Percent signs on both sides match the substring anywhere within the value.

Question 4

How do you select rows where a column does have a value (not null)?

Accepted Answer

WHERE column IS NOT NULL

Answer

IS NOT NULL is the correct syntax to test for a present value.

Question 5

Given WHERE a = 1 OR b = 2 AND c = 3, which is evaluated first?

Accepted Answer

b = 2 AND c = 3

Answer

AND has higher precedence than OR, so the AND pair is evaluated first.

SQL Practice Test