CREATE TABLE customer (state VARCHAR, acc_type VARCHAR, credit_score VARCHAR, no_of_loans VARCHAR)

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