Table 4-21 Selected Query Screen for Chapter Comprehensive Problem ... Query1 Lender Borrower Appraiser Lenderi Lender Name LenderAddress Appraiser Appraiser Name Borrower LastName FirstName CurrentAddress Re MortAmount Lenderi Appraiser Field: Table: Sort: Show: Criteria: or: a.Which borrowers use Advent Appraisers? List Borrower D, LastName, and Appraiser Name. b. List all of the property appraisers with the letter "d" in their name, sorted by name. List AppraiseriD and Appraiser Name cust all of the lenders who have participated in a transaction that used AppraiserID 8. Provide LenderName, Borrower, and ReqMortAmount d. List the lenders that lent more than $100,000. Provide Lender Name and Appraiser Name. Only list each combination of Lender Name and Appraiser Name once. Queries that use aggregate functions