For All Customers Who Have A Loan From The Bank Find Their #543
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: For all customers who have a loan from the bank, find their names and loan numbers with the attribute loan_number replaced by loan_id.
Answer:
select customer_name,loan_number as loan_id,amount from depositor natural join loan;
