SELECT avg(credit_score) FROM customer WHERE cust_id IN (SELECT cust_id FROM loan)
Find the average credit score of the customers who have some 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 )
Find the average credit score of the customers who have some loan .