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)
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)

Give me a histogram for what are the different names and credit scores of customers who have taken a loan?, and I want to order X in asc order please.
SELECT cust_name, credit_score FROM customer AS T1 JOIN loan AS T2 ON T1.cust_ID = T2.cust_ID ORDER BY cust_name
SELECT "cust_name", "credit_score" FROM "customer" "T1" JOIN "loan" "T2" ON "T1"."cust_ID" = "T2"."cust_ID" ORDER BY "cust_name"