The rows in the result of this query will be grouped by and…

The rows in the result of this query will be grouped by and sorted by SELECT vendor_name, COUNT(*) AS number_of_invoices,        MAX(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