What is the average account balance of customers with credit score below 50 for the different account types?
select avg(acc_bal), acc_type from customer where credit_score < 50 group by acc_type