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:
1. Find the names of branches with average balance above 700.
2. Find the names of customers with accounts at a branch where Hayes has an account.
3. Find the name and average balance for customers who live in Harrison and have at least 2 accounts.
NOTE
I want to screen capture of the last tables on the word document.
