Create a query that returns vendor ID, vendor name and the concatenation of the contact’s last and first name for each vendor whose contact has the same last name as another vendor’s contact. Use a self-join to check that the vendor id columns are not equal but the vendor contact last name columns are equal. This should return 2 rows.
What is the procedure that I should use to solve this problem?