Question: Show me the steps to solve Database Schema: branch ( branch _ name, branch _ city, assets ) customer ( cust _ ID , customer

Show me the steps to solve 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 ) Write a query to retrieve the loan_number, customer_name, and branch_name of customers who have a loan at the Yonkahs Bankahs branch and whose loan amount exceeds the average loan amount for that branch. Your solution must include a JOIN and a subquery. Hint: Remember, money data types do not perform well with aggregation. You will have to CAST twice here- on both sides of the comparison

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!