According to SQL-92:
"X BETWEEN Y AND Z" is equivalent to "X >= Y AND X <= Z"
Even if the BETWEEN
predicate is simply syntactic sugar, using it can improve the readability of a SQL WHERE clause, and is therefore
preferred.
Noncompliant code example
SELECT * FROM PERSONS
WHERE AGE >= 18 and AGE <= 60
Compliant solution
SELECT * FROM PERSONS
WHERE AGE BETWEEN 18 and 60