Problem $6$

Using a single sql statement, update all invoices in the InvoicesCopy table for which we have an

outstanding balance. For each of these invoices, change the payment date to today's date and the

payment total to the balance due. When setting the payment date, dynamically determine today's date

$($i$.$e$.,$ do NOT hard$-$code the value$).$

Hint: $11$ rows should be updated.