Can you show the average account balance of customers with credit score lower than 50 for each account type and their corresponding account types?
select avg ( acc_bal ), acc_type from customer where credit_score < 50 group by acc_type