SELECT vendor_state, vendor_city, vendor_name, COUNT(*) AS invoice_qty, SUM(invo

Question

SELECT vendor_state, vendor_city, vendor_name, COUNT(*) AS invoice_qty, SUM(invoice_total) AS invoice_average FROM invoices JOIN vendors ON invoices.vendor_id = vendors.vendor_id WHERE vendor_state < 'e' GROUP BY vendor_state, vendor_city, vendor_name HAVING SUM(invoice_total) > 500 ORDER BY vendor_state, vendor_city, vendor_name (Please refer to code example above.) When this summary query is executed, the result set will contain one summary row for Answer a. each city with invoice average over $500 b. each vendor with invoice totals over $500 c. each city with invoice totals over $500

Explanation / Answer

c. each city with invoice totals over $500

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.