human
Schema:
bank (branch_ID, bname, no_of_customers, city, state)
customer (cust_ID, cust_name, acc_type, acc_bal, no_of_loans, credit_score, branch_ID, state)
loan (loan_ID, loan_type, cust_ID, branch_ID, amount)
Please answer with SQL.
assistant
Sure, I understand.
human
Find the average number of customers cross all banks.
assistant
SELECT avg(no_of_customers) FROM bank
human
How many bank branches are there?
assistant
SELECT count(*) FROM bank
human
Find the total amount of loans provided by bank branches in the state of New York.
assistant
SELECT sum(T2.amount) FROM bank AS T1 JOIN loan AS T2 ON T1.branch_id = T2.branch_id WHERE T1.state = 'New York'
human
Find the branch name of the bank that has the most number of customers.
assistant
SELECT bname FROM bank ORDER BY no_of_customers DESC LIMIT 1
human
How many customers are there?
assistant
SELECT sum(no_of_customers) FROM bank
human
What is the total number of customers who use banks in New York City?
assistant
SELECT SUM( no_of_customers ) FROM bank WHERE city = "New York City" ;