For each account type, find the average account balance of customers with credit score lower than 50.
SELECT avg(acc_bal) ,  acc_type FROM customer WHERE credit_score  <  50 GROUP BY acc_type
average account balance = AVG(acc_bal); for each account type = GROUP BY acc_type; customers with credit score lower than 50 = WHERE credit_score < 50;