Using the relations of our sample bank database, write an SQL expression to define the following views:
Question:
Using the relations of our sample bank database, write an SQL expression to define the following views:
a. A view containing the account numbers and customer names (but not the balances) for all accounts at the Deer Park branch.
b. A view containing the names and addresses of all customers who have an account with the bank, but do not have a loan.
c. A view containing the name and average account balance of every customer of the Rock Ridge branch.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Question Posted: