Java Language

Write a script that declares and sets a variable equal to the total outstanding balance due in the Invoices table (TotalDue). If the outstanding balance due is less than $10,000, the script should display the message "Balance due is less than $10,000". If the outstanding balance due is greater than $10,000, the script should display a result set (the table below) consisting of VendorName, InvoiceNumber, InvoiceDueDate and the Balance (Invoice Total - PaymentTotal - CreditTotal) for each invoice with a balance due, in other words, with a balance greater than 0. Sort result such that the earliest due date appears first. Vendor Name InvoiceNumber InvoiceDueDate Balance Data Reproductions Corp 39104 4/9/2012 0:00 85.31 Ingram 31361833 4/10/2012 0:00 579.42 Federal Express Corporation 963253264 4/17/2012 0:00 52.25 134116 4/17/2012 0:00 90.36 263253268 4/20/2012 0:00 59.97 263253270 4/21/2012 0:00 67.92 Cardinal Business Media, Inc. Federal Express Corporation Federal Express Corporation Federal Express Corporation Malloy Lithographing Inc Ford Motor Credit Company 263253273 4/21/2012 0:00 30.75 P-0608 4/22/2012 0:00 19351.18 9982771 4/23/2012 0:00 503.2 Malloy Lithographing Inc 0-2436 4/30/2012 0:00 10976.06 Blue Cross 547480102 4/30/2012 0:00 224 Write a script that declares and sets a variable equal to the total outstanding balance due in the Invoices table (TotalDue). If the outstanding balance due is less than $10,000, the script should display the message "Balance due is less than $10,000". If the outstanding balance due is greater than $10,000, the script should display a result set (the table below) consisting of VendorName, InvoiceNumber, InvoiceDueDate and the Balance (Invoice Total - PaymentTotal - CreditTotal) for each invoice with a balance due, in other words, with a balance greater than 0. Sort result such that the earliest due date appears first. Vendor Name InvoiceNumber InvoiceDueDate Balance Data Reproductions Corp 39104 4/9/2012 0:00 85.31 Ingram 31361833 4/10/2012 0:00 579.42 Federal Express Corporation 963253264 4/17/2012 0:00 52.25 134116 4/17/2012 0:00 90.36 263253268 4/20/2012 0:00 59.97 263253270 4/21/2012 0:00 67.92 Cardinal Business Media, Inc. Federal Express Corporation Federal Express Corporation Federal Express Corporation Malloy Lithographing Inc Ford Motor Credit Company 263253273 4/21/2012 0:00 30.75 P-0608 4/22/2012 0:00 19351.18 9982771 4/23/2012 0:00 503.2 Malloy Lithographing Inc 0-2436 4/30/2012 0:00 10976.06 Blue Cross 547480102 4/30/2012 0:00 224