Combine Conditions
Part of the First Queries section of Coddy's PostgreSQL journey. Lesson 7 of 20.
AND requires both conditions to be true. OR accepts either condition. Parentheses group alternatives so an extra condition applies to the whole group.
Input table products:
id | name | category | price | stock | active | note |
|---|---|---|---|---|---|---|
1 | Map | travel | 12 | 5 | True | NULL |
2 | Notebook | books | 8 | 0 | True | Recycled |
3 | Atlas | books | 24 | 3 | False | NULL |
4 | Mug | home | 12 | 8 | True | Blue |
5 | lamp | home | 30 | 2 | False | Clearance |
6 | Mini map | travel | 6 | 10 | True | NULL |
SELECT id FROM products WHERE (category = 'home' OR category = 'books') AND price >= 20 ORDER BY id;The category group accepts home or books, then the price condition keeps ids 3 and 5. Without parentheses, AND binds more tightly than OR, which can change the selected rows.
Group alternatives with parentheses before combining them with AND.
Challenge
EasyReturn id and name for travel or books products that have stock greater than zero. Order by id.
The input tables are shown in the test panel. Each run starts from fresh data. Return the named columns in the stated order; do not hard-code the displayed rows.
Try it yourself
-- Write your SQL here.
This lesson includes a short quiz. Start the lesson to answer it and track your progress.
All lessons in First Queries
2Filter the Catalog
Filter with WHERECombine ConditionsMissing Values with NULLSearch Text with ILIKEFind Dispatch CandidatesPractice on your own: PostgreSQL playground