Database: loan_1
Question: What is the average credit score for customers who have taken a loan?
SQL:
SELECT avg(credit_score) FROM customer WHERE cust_id IN (SELECT cust_id FROM loan)