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

Find the state, account type, and credit score of the customer whose number of loan is 0.
SELECT state, acc_type, credit_score FROM customer WHERE no_of_loans = 0
SELECT "state", "acc_type", "credit_score" FROM "customer" WHERE "no_of_loans" = 0