Problem
Correct table joins and join fields: Vendors to Invoices (on VendorID) Invoices to InvoiceLineItems (on InvoiceID) InvoiceLineItems to GLAccounts (on AccountNo)
Write a select statement that returns 3 columns from the Invoices table: VendorID, InvoiceCount, and TotalPaid. InvoiceCount is the count of the number of invoices, and TotalPaid is the sum of the PaymentTotal and CreditTotal columns added together. Filter the results to only return rows where the balance due is equal to zero. Group the results by VendorID.