Consider the bank database, where the primary keys are underlined.
Construct the following SQL queries for this relational database.
a. Find all customers of the bank who have an account but not a loan.
b. Find the names of all customers who live on the same street and in
the same city as “Smith”.
c. Find the names of all branches with customers who have an account
in the bank and who live in “Harrison”.
branch(branch name, branch city, assets)
customer (customer name, customer street, customer city)
loan (loan number, branch name, amount)
borrower (customer name, loan number)
account (account number, branch name, balance )
depositor (customer name, account number)
