Structured-Query-Language

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.