Write a select statement that returns three columns from the vendors table: vendor_name, vendor_contact_last_name, and vendor_contact_first_name. then, run this statement to make sure it works correctly. add an order by clause to this statement that sorts the result set by last name and then first name, both in ascending sequence. then, run this statement again to make sure it works correctly. this is a good way to build and test a statement, one clause at a time.