CREATE TABLE customer (cust_id TEXT, cust_name TEXT, acc_type TEXT, acc_bal DECIMAL, no_of_loans DECIMAL, credit_score DECIMAL, branch_id DECIMAL, state TEXT)
CREATE TABLE loan (loan_id TEXT, loan_type TEXT, cust_id TEXT, branch_id TEXT, amount DECIMAL)
CREATE TABLE bank (branch_id DECIMAL, bname TEXT, no_of_customers DECIMAL, city TEXT, state TEXT)

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" > 100 GROUP BY "state"