Write a SELECT statement that answers this question: What are the last payment date and total amount due for each vendor with each terms id? Return these columns: The terms_id column from the Invoices
table The vendor_id column from the Invoice table The last payment date for each combination of terms
id and vendor id in the Invoices table. The sum of the balance due (invoice_total - payment_total - credit_total)
for each combination of terms id and vendor id in the Invoices table. Use the WITH ROLLUP operator to include rows
that give a summary for each terms id as well as a row that gives the ground total. This should return 40 rows.
Use the IF and GROUPING functions to replace the null values in the terms_id and vendor_id columns with literal
values if they are for summary row