IN and BETWEEN

How can we check membership in a list of values or a continuous range?

Intermediate⏱ 2 Minutes⭐ 140 XP

🤔 THE QUESTION

How can we check membership in a list of values or a continuous range?

💡 WHAT IS IT?

IN checks for inclusion in a list, and BETWEEN filters for values within an inclusive range.

🎯 WHAT IS IT USED FOR?

Categorical filtering (departments, countries) and range filtering (salary brackets, date windows).

💻 EXAMPLE

SELECT *
FROM employees
WHERE department IN ('IT', 'HR')
AND salary BETWEEN 40000 AND 80000;

Practice typing production-grade SQL code for IN and BETWEEN.