Q1. This is Exercise #2 of end of Chapter 4 (p.156)

Write a SELECT statement that returns four columns:

VendorName From the Vendors table

InvoiceNumber From the Invoices table

InvoiceDate From the Invoices table

Balance Derived from the Invoices table,

i.e., InvoiceTotal minus the sum of PaymentTotal and CreditTotal

The result set should have one row for each invoice with a non-zero balance. Sort

the result set by VendorName in ascending order.

Hint: correct query results 11 rows