BETWEEN operator is used to filter the result set within a certain range. The values can be numbers, text or dates.
SELECT * FROM movies
WHERE name BETWEEN 'A' AND 'J';
This statement filters the result set to only include movies with
names that begin with letters "A" up to but not including "J".
SELECT * FROM movies WHERE year BETWEEN 1990 AND 2000;
In this statement, the
BETWEEN operator is being used to filter the result set to only include movies with
years between 1990 up to and including 2000.