Write a SELECT statement that returns one column from the Vendors table named vendor_address that joins the vendor_addre

[answerhappygod]

Write a SELECT statement that returns one column from theVendors table named vendor_address thatjoins the vendor_address1 and vendor_address2 columns.Format this column with the vendor_address1, one space, four dashes(----), one space and thevendor_address2 like this:Attn: Supt. Window Services ---- PO Box 7005Sort the result set by vendor_name in ascending sequence.Return only those rows where vendor_address1 and vendor_address2are not null and vendor_address2must start with ‘P’.This should give 9 rows. Please show a screenshot of the executedquery.