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.
This doesn't make sense to me, what's the difference between apart from data types? Why one is exlusive and the other is inclusive?