How_to_retrieve_data_from_a_single_table/Exec_3_25.sql

SELECT vendor_id,
       vendor_name,
       concat(vendor_contact_first_name, vendor_contact_last_name) AS contact_name 
FROM vendor v
WHERE vendor_id = vendor_contact_last_name
ORDER BY vendor_contact_last_name;