Find All The Bank Customers Having Both A Loan And An Account #548
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 bank customers having both a loan and an account at the bank
select customer_name from borrower;
Answer:
select customer_name from depositor intersect allselect customer_name from borrower;
