Referring to the diagram above, which SELECT statement would appropriately display columns showing borrowers names who used the appraiser "Bob's Appraisal Service"?

Select one:

A$.$ SELECT AppraiserName, LenderName.

B$.$ SELECT AppraiserNam

C$.$ SELECT BorrowerID, LenderID.

D$.$ SELECT FirstName, LastName.

E$.$ None of the SELECT statements would display the correct information.

Clear my choice