Between

The BETWEEN operator is used to match a value with a range of values. The expression returns true if the value is greater than or equal to the low value and less than or equal to the high value, and false otherwise.

BETWEEN operator,

You can also rewrite it using the ‘greater than or equal ( >=)’ or ‘less than or equal ( <=)’ operators.

.. BETWEEN low_value AND high_value;

SELECT customer_id, payment_id, amount FROM payment WHERE
amount BETWEEN 8 AND 9;

SELECT customer_id, payment_id, amount FROM payment WHERE
amount NOT BETWEEN 8 AND 9;

SELECT customer_id, payment_id, amount, payment_date FROM
payment WHERE payment_date BETWEEN '2007-02-07' AND '2007-02-15';