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.


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

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.