select first_name, last_name, credit_limit
from customer
where credit_limit between 500 and 800

##</code><code>##

select first_name, last_name, credit_limit
from customer
where credit_limit > 500 and credit_limit < 800