If you run this query, the number_of_invoices for each row w…

If you run this query, the number_of_invoices for each row will show the number SELECT vendor_name, COUNT(*) AS number_of_invoices,        MIN(invoice_total – payment_total – credit_total) AS balance_due FROM vendors v   JOIN invoices i   ON v.vendor_id = i.vendor_id  WHERE invoice_total – payment_total – credit_total