SQL

Write a SELECT statement that returns four columns:
VendorName       From the Vendorstable
InvoiceNumber   From the Invoice table
InvoiceDate       From the Invoicetable
Balance       InvoiceTotal minus the sumof PaymentTotal and CreditTotal
The result set should have one row for each invoice with a non-zerobalance. Sort the result set by VendorName in ascendingorder.
Here is result set with 11 rows:

Balance VendorName Invoice Num... InvoiceDate 5474

Balance VendorName Invoice Num… InvoiceDate 547480102 2012-04-01 00:00:00 224.00 Blue Cross 2 Cardinal Business Media Inc. 134.116 2012-03-28 00:00:00 90.36 2012-03-10 00:00:00 85.31 Data Reproductions Corp 39104 4 Federal Express Corporation 963253264 2012-03-18 00:00:00 52.25 5 Federal Express Corporation 263253268 2012-03-21 00:00:00 59.97 6 Federal Express Corporation 263253270 2012-03-22 00:00:00 67.92 7 Federal Express Corporation 263253273 2012-03-22 00:00:00 30.75 Ford Motor Credit Company 9982771 2012-03-24 00:00:00 503.20 9 Ingram 31361833 2012-03-21 00:00:00 579.42 2012-03-31 00:00:00 10976.06 10 Malloy Lithographing Inc 0-2436 2012-03-23 00:00:00 19351.18 P-0608 11 Malloy Lithographing Inc Show transcribed image text