---价格在15到20之间
SELECT *
FROM titles
WHERE price BETWEEN 15 AND 20
等价于
---价格在15到20之间
SELECT *
FROM titles
WHERE price > 15 and price < 20
---价格不在15到20之间
SELECT *
FROM titles
WHERE price not BETWEEN 15 AND 20
等价于
---价格在15到20之间
SELECT *
FROM titles
WHERE price < 15 or price > 20