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
total account balance refers to SUM(acc_bal); customers with a credit score of above 100 refers to WHERE credit_score > 100; for the different states refers to GROUP BY state;