CREATE TABLE loan (loan_id CLOB, loan_type CLOB, cust_id CLOB, branch_id CLOB, amount NUMBER)
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 bank (branch_id NUMBER, bname CLOB, no_of_customers NUMBER, city CLOB, state CLOB)

For each account type, find the average account balance of customers with credit score lower than 50.
SELECT AVG(acc_bal), acc_type FROM customer WHERE credit_score < 50 GROUP BY acc_type
SELECT AVG("acc_bal"), "acc_type" FROM "customer" WHERE "credit_score" < 50 GROUP BY "acc_type"