The OR keyword

Part of the Fundamentals section of Coddy's SQL journey — lesson 7 of 72.

The OR keyword means that we want one of the conditions to be true.

For example consider the following people table:

SELECT * 
FROM people
WHERE gender = 'female' OR age < 20

This query means that we are looking for all records that either the gender is female or the age is less than 20.

This will be the result:

Challenge

Easy

Available tables and columns:
people: age, status

Fetch all of the people who are either under age of 20 or above age 28 (not including 20 and not including 28).

Try it yourself

SELECT * 
FROM people
-- Write your code below
WHERE

Test yourself

This lesson includes a short quiz. Start the lesson to answer it and track your progress.

All lessons in Fundamentals