CODE EXAMPLE FOR SQL

use between operator in mysql

SELECT * FROM cars.customers
where creditLimit 
between 20000 and 500000;