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 branchname, branchcity, assets customer custID customername, customerstreet, customercity loan loannumber, branchname, amount borrower custID loannumber account accountnumber, branchname, balance depositor custID accountnumber Write a query to retrieve the loannumber, customername, and branchname 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
