WeCodeAcademy

IN and BETWEEN

IN checks a list of values. BETWEEN checks a range, including both ends.

Examplesql
Open in editor »

NOT IN and NOT BETWEEN give the opposite.

Examplesql
Open in editor »
Quick check

Which is the same as `age >= 30 AND age <= 40`?

Your turn: write the code

Return the names of products priced between 4 and 25 (inclusive), sorted by name.

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.