1) The a is intiuded in your sql code. a. Use comments to show your name and the query number submission. 2) The first 5 (or less) lines of the results tab, with headings (if applicable). If asked, show the data before and after the change. The output in the messages tab 3) Please create solutions to the following queries: Write SELECT INTO statements to create one table named Invoicecopysyour in of the Invoices tables. I 1. initials> that is a complete copy statement that adds a row to the Invoicecopy table with the following values: VendoriD 32 InvoiceTotal: $434.58 TermsID: 2 InvoiceNumber: AX-014-027 PaymentTotal: 50.00 InvoiceDueDate: today's date+ 30 InvoiceDate: today's date CreditTotal: $o.00 PaymentDate: null b. Write a statement that will verify that the data was inserted (not just a select from your table. Target the specific data just inserted). 3a. Write a statement that will create a new Vendorcopycyour initials> table, based on the Vendors table BUT only add the rows for vendors located in Michigan. b. Write a statement that verifies that the rows were added Modify the endorcopy table. Change the default account number to 110 for each vendor that has a default account number of 400. Make sure you show the data before and then after the change in your answer submission. 4. Write an UPDATE statement that modifies the Invoicecopycyour initialss table. Change the PaymentDate to today's date and the PaymentTotal to the balance due for each invoice with a balance due. Set today's date 5. using the GETDATE0 function. 6. Write a statement that deletes all invoices that have a TermsiD of 1 or 2, from the Invoicecopy table both the Vendorcopycyour initials> and 7. Write a delete statement that will remove all of the data from r-initials> tables (don't delete the table though). How can you verify that the data is gone and invoicecopycyou not the table? 8. Write a statement that will remove the tables, you created, from the d acer