SELECT sum(acc_bal) ,  state FROM customer WHERE credit_score  >  100 GROUP BY state
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
select sum ( acc_bal ) , state from customer where credit_score > value group by state
What is the total account balance for customers with a credit score of above 100 for the different states ?