Find The Customer Names Loan Numbers And Loan Amounts For All #542
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 the customer names, loan numbers, and loan amounts, for all loans at the Perryridge branch.
Answer:
select customer_name,loan_number,amount from depositor natural join loan where loan.branch_name=’Perryridge’;
