Find All The Customers Who Have Both A Loan And An Account At #555
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 the customers who have both a loan and an account at the Perryridge branch
customer_name in
(select customer_name from account natural join depositor
where branch_name = ‘Perryridge’);
Answer:
select customer_name from loan natural join borrower where branch_name = ‘Perryridge’ andcustomer_name in
(select customer_name from account natural join depositor
where branch_name = ‘Perryridge’);
