Select The Names Of Customers Who Have A Loan At The Bank And #557
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: Select the names of customers who have a loan at the bank, and whose names are neither Smith nor Jones
(‘Smith’, ‘Jones’);
Answer:
select customer_name from loan natural join borrower where branch_name = ‘Perryridge’ and customer_name not in(‘Smith’, ‘Jones’);
