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