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

After running this query, what is the result?SELECT vendor_s…

After running this query, what is the result?SELECT vendor_state, vendor_city, vendor_name, COUNT(*) AS invoice_quantity,   SUM(invoice_total) AS invoice_total_overallFROM invoices JOIN vendors   ON invoices.vendor_id = vendors.vendor_idWHERE vendor_state  REGEXP “M”GROUP BY vendor_state, vendor_city, vendor_nameHAVING SUM(invoice_total)

If you run this query, the result table will contain one row…

If you run this query, the result table will contain one row for SELECT i.vendor_id, MIN(i.invoice_total) AS smallest_invoiceFROM invoices i    JOIN      (SELECT vendor_id, AVG(invoice_total) AS average_invoice     FROM invoices     GROUP BY vendor_id     HAVING AVG(invoice_total)