Q3. This is Exercise #6 of end of Chapter 4 (p.157)

Write a SELECT statement that returns three columns:

VendorID From the Vendors table

VendorName From the Vendors table

Name A concatenation of VendorContactFName and VendorContactLName,

with a space in between

The result set should have one row for each vendor whose contact has the same first name as

another vendors contact. Sort the final result set by Name.

Hint 1: Use a self-join

Hint 2: correct query results 6 rows