AND, OR and NOT

Combine conditions with AND (both must be true), OR (either), and NOT. Use brackets when you mix them.

Examplesql

Examplesql

Quick check

`WHERE a AND b` returns rows where...

Either condition is trueBoth conditions are trueNeither condition is true

Your turn: write the code

Return the names of customers who live in Paris and are older than 30.

Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.

Tip: use the left and right arrow keys to move between lessons.