Answer:
SELECT vendor_number, vendor_name, CONCAT ('street', ' ' , 'city', ' ' , 'state', ' ' , 'zip code') as adress
FROM vendor_directory
ORDER BY vendor_name ASC;
Explanation:
* Suppose <u>vendor_directory</u> is the name of the table from which you extract the data with the SELECT sentence.
The device which typically combines the capabilities of a scanner , fax ,and copying machine is called an input device.
