Database Schema:

branch ( branch_name, branch_city, assets )

customer ( cust_ID, customer_name, customer_street, customer_city )

loan ( loan_number, branch_name, amount )

borrower ( cust_ID, loan_number )

account ( account_number, branch_name, balance )

depositor ( cust_ID, account_number )

PLEASE INCLUDE A SUBQUERY IN THE ANSWER

The answer MUST include at least one subquery for it to be right like a (SELECT ) subquery

Question 6 (Must include subquery): Write a query that returns every customer that has a loan at Yonkahs Bankahs. Include the customer name and branch name for verification.