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.
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
