SELECT i.vendor_id, MAX(i.invoice_total) AS largest_invoice FROM invoices i JOIN

Question

SELECT i.vendor_id, MAX(i.invoice_total) AS largest_invoice FROM invoices i JOIN (SELECT vendor_id, AVG(invoice_total) AS average_invoice FROM invoices GROUP BY vendor_id HAVING AVG(invoice_total) > 100 ORDER BY average_invoice DESC) ia ON i.vendor_id = ia.vendor_id GROUP BY i.vendor_id ORDER BY largest_invoice DESC (Please refer to code example above.) When this query is executed, the result table will contain one row for Answer a. each invoice b. each vendor in the table named ia c. each vendor

Explanation / Answer

a. each invoice

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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