Murach’s SQL for SQL Server – Exercise 13 – Guaranteed 100% Score
Murach’s SQL for SQL Server – Exercise 13 – Guaranteed 100% Score 1. 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, return the message “Balance due is less than $10,000.00.” 2. The following script uses a derived table to return the date and invoice total