write a select statement that returns these three columns:

vendor_id The vendor_id column from the Vendors table

vendor_name The vendor column from the Vendors table

contact_name A concatenation of the vendor_contact_first_name and vendor_contact_last_name columns with a space in between

Return one row for each vendor whose contact has the same last name as anothers vendor contact. Should return 2 rows. HINT: Use self-join to check

Murach's MySQL 2nd Editon.