SELECT * FROM movie_titles WHERE our_cost BETWEEN 11.00 and 27.50 ;

10 BETWEEN 5 AND 15 Is true, but: 10 BETWEEN 15 AND 5 Is false:

because the equivalent way of expressing BETWEEN (using AND) has a specific order that does not matter when you are using literals, but might matter a good deal if you provide value2 and value3 by using host variables, parameters, or even subqueries.