The result of this query will containSELECT vendor_name, COU…
The result of this query will containSELECT vendor_name, COUNT(*) AS number_of_invoices, AVG(invoice_total – payment_total – credit_total) AS max_balance_dueFROM vendors v JOIN invoices i ON v.vendor_id = i.vendor_id WHERE invoice_total – payment_total – credit_total