CREATE TABLE bank (branch_ID NUMBER, bname VARCHAR2, no_of_customers NUMBER, city VARCHAR2, state VARCHAR2)
CREATE TABLE loan (loan_ID VARCHAR2, loan_type VARCHAR2, cust_ID VARCHAR2, branch_ID VARCHAR2, amount NUMBER)
CREATE TABLE customer (cust_ID VARCHAR2, cust_name VARCHAR2, acc_type CHAR, acc_bal NUMBER, no_of_loans NUMBER, credit_score NUMBER, branch_ID NUMBER, state VARCHAR2)

What is the average account balance of customers with credit score below 50 for the different account types Visualize by bar chart, and order by the names in ascending please.
SELECT acc_type, AVG(acc_bal) FROM customer WHERE credit_score < 50 GROUP BY acc_type ORDER BY acc_type
SELECT "acc_type", AVG("acc_bal") FROM "customer" WHERE "credit_score" < 50 GROUP BY "acc_type" ORDER BY "acc_type"