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

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"