We're sorry but this app doesn't work properly without JavaScript enabled. Please enable it to continue.

This lesson's interactive features are locked, please to keep using them

OR

As you've probably guessed, if the logical AND operator is supported, the OR operator is probably supported as well.

SELECT product_name, quantity, shipment_status
FROM products
WHERE shipment_status = 'out of stock'
  OR quantity BETWEEN 10 and 100;

This query retrieves records where either the shipment_status condition or the quantity condition is met.

Order of Operations

You can group logical operations with parentheses to specify the order of operations.

(this AND that) OR the_other

Assignment

The laws have changed again! Now we need to see how many affected users meet these criteria:

Users who are from the United States or Canada, and are under 18

Write a query that retrieves the count of all users (aliased to junior_count) who match the conditions above.