What is the total account balance for customers with a credit score of above 100 for the different states?
select sum(acc_bal), state from customer where credit_score > 100 group by state