From the database created in the comprehensive problem (also available at http://www.pearsonhighered.com/romney), perform queries based on the tables and query grid. Your instructor may specify whether you are to use Design view or SQL view.

a. Which borrowers use Advent Appraisers? List Borrower ID, Last Name, Appraiser Name.

b. List all of the property appraisers with the letter “d” in their name, sorted by name.
List AppraiserID and AppraiserName.

c. List all of the lenders who have participated in a transaction that used AppraiserID 8.
Provide LenderName, BorrowerID, and ReqMortAmount.

d. List the lenders that lent more than \($100,000.\) Provide LenderName and AppraiserName. Only list each combination of LenderName and AppraiserName once.

e. What is the average amount borrowed from each lender? Provide LenderID, LenderName, and AvgMortAmt. Sort by AvgMortAmt in descending order. Consider using ROUND() to present at 2 decimal places.

f. How many appraisals did each appraiser perform? Provide AppraiserName and CountOfAppraisals.

g. Which borrower requested the largest mortgage? Provide BorrowerID, LastName and ReqMortAmount.

h. Which borrower requested the smallest mortgage? Provide BorrowerID, LastName and ReqMortAmount.