Use of BETWEEN in RDBMS

It is used for specifying a range to test

Example

SELECT title_id, ytd_sales
FROM
WHERE ytd_sales BETWEEN 4095 AND 12000