A condition like year >= 2 AND year <= 4 is equivalent to BETWEEN 2 AND 4.
year >= 2 AND year <= 4
BETWEEN 2 AND 4
Due to >= and <=, it selects values between 2 and 4 for the same column, year.
>=
<=
2
4
year
Make sure to pick BETWEEN followed by 2 and then AND, 4.
BETWEEN
AND