Source
SnowConvert AI - Redshift - Conditions
A BETWEEN condition tests expressions for inclusion in a range of values, using the keywords BETWEEN and AND.