Create and execute a select statement that would provide data for a vendor directory. display should include vendor number, vendor name, street, city, state, zip code. concatenate the address elements to look like ‘1234 main street state college, pa 16802’. override the column labels with meaningful descriptions. directory display should be sorted by vendor name ascending.