For each state, find the total account balance of customers whose credit score is above 100.
SELECT sum(acc_bal) ,  state FROM customer WHERE credit_score  >  100 GROUP BY state
total account balance = SUM(acc_bal); each state refers to GROUP BY state; customers whose credit score is above 100 refers to WHERE credit_score > 100;