use > and < instead of between

Example

SELECT title_id, ytd_sales
FROM titles
WHERE  ytd_sales > 4095 AND ytd_sales < 12000