Write SQL queries for the following: a. Write an insert statement that adds this row to the invoices table invoice_id: the next id in the sequence (find out which sequence this should be) vendor_id: 35 invoice_number: AX-014-027 invoice_date: 09-26-2017 invoice_total: $850.58 payment_total:$0.00 credit_total:$0.00 terms_id: 2 invoice_due_date: 10-09-2017 payment_date: null a. Use to_date() function b. Use select statement to show the new record submit the following: i. script of the insert statement and select statement. ii. Screenshot of the result from the select statement

b. Update that row by adding $600 to the payment_total. Calculate the difference from the invoice_total and update the credit_total accordingly. Finally, make the payment_date as of today's date. a. Use select statement to show the updated record submit the following: i. script of the update statement and select statement. ii. Screenshot of the result from the select statement