How_to_retrieve_data_from_a_single_table/Exec_2.sql

SELECT CONCAT(vendor_contact_last_name,vendor_contact_first_name) AS full_name
FROM vendors
WHERE vendor_contact_last_name < 'A',
      vendor_contact_last_name < 'B',
      vendor_contact_last_name < 'C',
      vendor_contact_last_name < 'E'
ORDER by vendor_contact_last_name,
	 vendor_contact_first_name;