From the database created in the comprehensive problem, perform queries based on the table...

From the database created in the comprehensive problem, perform queries based on the tables and query grid shown in Table.

a. Which borrowers use Advent Appraisers?

---

b. What is the average amount borrowed from National Mortgage?

---

c. List all of the property appraisers.

---

d. List all of the lenders.

---

e. List the lenders that lent more than $100,000.

---

f. Which borrower requested the largest mortgage?

---

g. Which borrower requested the smallest mortgage?

TABLE Selected Query Screen for Chapter Comprehensive Problem