Chapter 3

Filtering & Joining — quiz

5 questions · ~4 min

Chapter 3 quiz

Question 1 of 5

You want orders that are either 'pending' or 'processing' AND for users in countries US, UK, or CA. Which is the cleanest, correct WHERE clause?

WHERE status = 'pending' OR status = 'processing' AND country = 'US' OR country = 'UK' OR country = 'CA'
WHERE status IN ('pending', 'processing') AND country IN ('US', 'UK', 'CA')
WHERE status = 'pending' OR 'processing' AND country = 'US' OR 'UK' OR 'CA'
WHERE status BETWEEN 'pending' AND 'processing' AND country IN ('US', 'UK', 'CA')