Please solve both the question this is my last question I really need please do them correctly. You have to write SQL queries

4. (Part A) write a SELECT INTo statement to create a test table named InvoiceCopyB that is a complete copy of the ices table. In case In already exists, first code a DROP TABLE statement to delete it. (Part B) write an INSERT statement that adds a row to the InvoiceCopyB table with the following values: InvoiceID: 1000 VendorID: 32 nvoiceTotal: $160.39 TermsID: 2 Invoice Numb AL27 PaymentTotal: $0.00 Invoice DueDate: 5/26/16 Invoice Date: 4/26/16 CreditTotal: $0.00 Payment Date: NULL (part c) write an UPDATE statement that modifies that record added to the InvoicecopyB table in Part B of this question (InvoiceID 1000). Change the InvoiceNumber from A127 to A1100. 5. create a stored procedure named PayUnpaid lnvoicesForvendorx that pays the unpaid invoices in the invoicecopy table for vendorid 83 that are unpaid. Pay the full invoicetotal amount and set the payment date to today's date