Question: Write a script that declares and sets a variable that's equal to the total outstanding balance due. If that balance due is greater than $10,000.00,
Write a script that declares and sets a variable that's equal to the total outstanding balance due. If that balance due is greater than $10,000.00, the script should return a result set consisting of VendorName, InvoiceNumber, InvoiceDueDate, and Balance for each invoice with a balance due, sorted with the oldest due date first. If the total outstanding balance due is less than $10,000.00, the script should return the message "Balance due is less than $10,000.00."
(SQL Language)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
