Question: 9. Write a SELECT statement that uses aggregate window functions to calculate the total due for all vendors and the total due for each vendor.
9. Write a SELECT statement that uses aggregate window functions to calculate the total due for all vendors and the total due for each vendor. Return 3 Columns: The vendor id from the Invoices table. The balance due (invoice_total-payment_total-credit_total) for each invoice in the invoices table with a balance greater than 0. The total balance due for all vendors in the Invoices table. Modify the column that contains the balance due for each vendor so it contains a cumulative total by balance due.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
