The BETWEEN operator chooses values from a predetermined range. The values could be text, integers, or dates.

The BETWEEN operator includes both the begin and finish variables.

Between Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;