7. branch(branch name, branch city, assets)

customer (ID, customer name, customer street, customer city)

loan (loan number, branch name, amount)

borrower (ID, loan number)

account (account number, branch name, balance )

depositor (ID, account number)

Consider the bank database above, where the primary keys are underlined.

Construct the following SQL queries for this relational database.

i. Find each customer who has an account at every branch located in Brooklyn.

ii. Find the total sum of all loan amounts in the bank.

iii. Find the names of all branches that have assets greater than those of at least one branch located in Brooklyn.