For each state, find the total account balance of customers whose credit score is above 100.
CREATE TABLE customer (state VARCHAR, acc_bal INTEGER, credit_score INTEGER)
SELECT SUM(acc_bal), state FROM customer WHERE credit_score > 100 GROUP BY state
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: 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. [/INST] SELECT SUM(acc_bal), state FROM customer WHERE credit_score > 100 GROUP BY state </s>