what are the names of customers with a credit score lower than 50?
select cust_name from customer where credit_score < 50
what is their average account balance?
select avg(acc_bal) from customer where credit_score < 50
find their average account balance for each different account type.
select avg(acc_bal), acc_type from customer where credit_score < 50 group by acc_type