Return rows where the Vendors are from Ohio or New York

Write a select statement that returns 4 columns: • VendorName • VendorCity • VendorState • VendorZipCode Filter the results to only return rows where the Vendors are from Ohio or New York (use the list of values comparison operator), or reside in Fresno. Sort the results by VendorState and then be VendorCity.