Between Range — Solution & ExplanationProblems / Between Range / EditorialApproachBETWEEN is shorthand for a range check with two comparisons.

WHERE amount BETWEEN 100 AND 300 keeps rows where amount is 100, 300, or anything in between.

This is equivalent to amount >= 100 AND amount <= 300.

BETWEEN is inclusive on both ends, which is a common interview question.Hints

BETWEEN is inclusive on both ends: BETWEEN 100 AND 300 includes 100 and 300.

You can also write this as: amount >= 100 AND amount <= 300.

In PySpark, use .between(low, high) on a column.