Consider the following Bank database, where the Primary keys are underlined.

branch (branch name, branch_city, assets)

customer (customer name, customer_street, customer_city)

loan (loan number, branch name, amount)

borrower (customer name, loan number)

account (account number, branch name, balance)

depositor (customer name, account number)

For the above database, write the following SQL queries.

(i) A query to prepare a list of all customers who have an account at all the branches located in Dhaka

(ii) A query to find out the total loan amount of a branch

(iii) A query to prepare a list of all branches that have assets greater than the asset of at least one branch located in Dhaka

(iv) A query to find out the total loan amount of a customer