Create and execute a SELECT statement that would provide data for a vendor directory. Display should include vendor number, vend
or 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.