(Solution) - Using the relations of our sample bank database write an -(2025 Original AI-Free Solution)

Paper Details

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.