Find All Customers Who Do Have A Loan At The Bank But Do Not #556
This subjective question is related to the book/course
gs gs114 Relational Database Management System.
It can also be found in
gs gs114 Practical Questions Solved Past Paper No. 1.
Question 1: Find all customers who do have a loan at the bank, but do not have an account at the bank.
(select customer_name from account natural join depositor);
Answer:
select customer_name from loan natural join borrower where customer_name not in(select customer_name from account natural join depositor);
