4. Please write the SQL code. List information about vendors in the Vendor table. The vendors are located in either California or Nevada. Concatenate the Address1, City, and State columns into a single column and call it VendorAddress. Format the phone number using standard U.S. formatting. Format the FirstBuyDate as Nov 15, 2001. Sort the result table by FirstBuyDate.