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
How many bank branches are there?
assistant
SELECT count(*) FROM bank
human
Find the city and name of bank branches that provide business loans.
assistant
SELECT T1.bname , T1.city FROM bank AS T1 JOIN loan AS T2 ON T1.branch_id = T2.branch_id WHERE T2.loan_type = 'Business'
human
Find the number of different cities which banks are located at.
assistant
SELECT count(DISTINCT city) FROM bank
human
Find the name of bank branches that provided some loans.
assistant
SELECT DISTINCT T1.bname FROM bank AS T1 JOIN loan AS T2 ON T1.branch_id = T2.branch_id
human
Find the branch names of banks in the New York state.
assistant
SELECT bname FROM bank WHERE state = 'New York'
human
What city and state is the bank with the name morningside in?
assistant
SELECT city , state FROM bank WHERE bname = "morningside" ;