What are the states, account types, and credit scores for customers who have 0 loans?
select state, acc_type, credit_score from customer where no_of_loans = 0