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 customers on streets with names ending in “Hillâ€œ.

2. Print loan data, ordered by decreasing amounts, then increasing loan numbers.

3. Print the names and cities of customers who have a loan at Perryridge branch.

NOTE

I want to screen capture of the last tables on the word document.