how many customers have at least one loan?
select count(*) from customer where cust_id in (select cust_id from loan)
which states are they from?
select state from customer where cust_id in (select cust_id from loan)
show their credit scores.
select credit_score from customer where cust_id in (select cust_id from loan)
what is the average?
select avg(credit_score) from customer where cust_id in (select cust_id from loan)