text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE customer (state VARCHAR, acc_bal INTEGER, credit_score INTEGER)
  ### Question:
  For each state, find the total account balance of customers whose credit score is above 100.
  ### Answer:
  SELECT SUM(acc_bal), state FROM customer WHERE credit_score > 100 GROUP BY state