CODE EXAMPLE FOR SQL

between

select count(payment_id) as num_payments
from payment
where amount between 3 and 5;