(a) Find the names of branches with average branch balance above 700.

(b.) Find all customers who have a loan, an account, or both

(c) Find the average account balance at the Perryridge branch.

In-class exercise Consider the banking example we used in lecture: branch (branch-name, branch-city, assets) customer (customer-name, customer-street, customer-city) account (account-number, branch-name, balance) loan (loan-number, branch-name, amount) depositor (customer-name, account-number) borrower (customer-name loan-number) Write and execute the following queries in SQL