Create and execute a SELECT statement that would provide data for a vendor directory. Display should include customer number, customer name, street, city, state, zip code. Concatenate the address elements to look like ‘7440 Junction Road Sacramento, CA 95345'.