Use Comparisons and Logic

You know how to filter rows with WHERE. Now let’s go deeper and combine conditions using AND, OR, and NOT.

Goal

You’ll aim to:

• Use multiple conditions in a WHERE clause.

• Combine logic using AND, OR, and NOT.

Tables

Let’s use the following table in this lesson:

The people table