Consider the bank database of Figure 3.19, 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”.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here