In SQL, using a company accounts payable (AP) database write an executable SQL Script that satisfies the following prompts:

Table Joins Reference is attached below, thanks!

8. Create a script that displays VendorName, InvoiceDate, InvoiceNumber and AccountDescription, however set up the script so the column names display as Vendor, Date, Number and Description. Sort the results by Vendor and Description. (query results - 118 rows returned) 9. Bill wants to find out how many of his vendors are in the same VendorZipCode that do not have a name starting with the letter C. When you create the script, display VendorName, VendorCity, VendorState and VendorZipCode columns in the results and sort it by VendorState, VendorName and VendorZipCode. Bill said the last script writer he worked with used a self join to extract this type of information. Looking up the best way to create the script, you located these notes: - Use a specific keyword in the SELECT clause that will remove duplicate values - Correlate the tables and qualify every column - Use the field that contains the same values you're looking for as the join field - Add criteria where one tables common field does not equal the other tables common field (query results - 31 rows returned) Submit the 9 completed scripts within a zip folder in the Basics SQL Clauses Assignment page. Vendors joins Invoices using VendorID Invoices joins InvoiceLineItems using InvoiceID InvoiceLineItems join GLAccounts using AccountNo