SELECT avg(credit_score) FROM customer WHERE cust_id IN (SELECT cust_id FROM loan)
What is the average credit score for customers who have taken a loan?
SELECT avg ( credit_score ) FROM customer WHERE cust_id IN ( SELECT cust_id FROM loan )
select avg ( credit_score ) from customer where cust_id in ( select cust_id from loan )
What is the average credit score for customers who have taken a loan ?