

0 / 2 embers
0 / 3000 xp
click for more info
Complete a lesson to start your streak
click for more info
Difficulty: 10
click for more info
Not enough gems
Cost: 6 gems
1: AS Clause in SQL
incomplete
2: SQL Functions
incomplete
3: Between
incomplete
4: Distinct
incomplete
5: Logical Operators – AND
incomplete
6: OR
incomplete
7: In
incomplete
8: Like
incomplete
9: Underscore Operator
incomplete
10: Wildcards Quiz
incomplete
11: Query Practice – Discount Program
incomplete
Back
ctrl+,
Next
ctrl+.
This lesson's interactive features are locked, please to keep using them
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.
You can group logical operations with parentheses to specify the order of operations.
(this AND that) OR the_other
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.