Code example 6-2 SELECT i.vendor_id, MAX(i.invoice_total) AS largest_invoice FRO

Question

Code example 6-2 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 6-2.) When this query is executed, the result table will contain one row for Answer a. each invoice in the table named ia b. each vendor in the table named ia c. each vendor d. each invoice

Explanation / Answer

a. each invoice

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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