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 number of different cities which banks are located at.
assistant
SELECT count(DISTINCT city) FROM bank
human
Find the average number of customers in all banks of Utah state.
assistant
SELECT avg(no_of_customers) FROM bank WHERE state = 'Utah'
human
How many bank branches are there?
assistant
SELECT count(*) FROM bank
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
Find the number of different states which banks are located at.
assistant
SELECT count(DISTINCT state) FROM bank
human
Which state has the greatest total number of bank customers?
assistant
SELECT state FROM bank GROUP BY state ORDER BY SUM( no_of_customers ) DESC LIMIT 1 ;