This is in SQL

5. Write an UPDATE statement that modifies the InvoiceCopy table. Change the PaymentDate to todays date and the PaymentTotal to the balance due for each invoice with a balance due. Set todays date with the GETDATE() function.Show the query and the number of affected rows in the assignment submission.

6. Write an UPDATE statement that modifies the InvoiceCopy table. Change TermsID to 2 for each invoice thats from a vendor with a DefaultTermsID of 2. Use a JOIN clause. Show the query and the number of affected rows in the assignment submission.