CREATE TABLE customer (state VARCHAR, acc_bal INT, credit_score INT)

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
SELECT SUM("acc_bal"), "state" FROM "customer" WHERE "credit_score" > 100 GROUP BY "state"