The NOT keyword

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

The NOT keyword means that we don't want the condition to be met.

For example consider the following people table:

SELECT * 
FROM people
WHERE NOT gender = 'male'

This will be the result:

name	age	gender
Nohlas	24	female
Loopa	18	female

The NOT keyword basically flips the condition. For example the following queries are the same:

WHERE age > 20

WHERE NOT age <= 20

Challenge

Easy

Available tables and columns:
people: name, age, status

Fetch all of the people where the status is NOT retired

Cheat sheet

The NOT keyword is used to negate a condition, meaning we don't want the condition to be met.

SELECT * 
FROM people
WHERE NOT gender = 'male'

The NOT keyword flips the condition. These queries are equivalent:

WHERE age > 20

WHERE NOT age <= 20

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.