Code example $7-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)$ ia

ON i$.$vendor$\_$id $=$ ia$.$vendor$\_$id

GROUP BY i$.$vendor$\_$id

ORDER BY largest$\_$invoice DESC

$($Refer to code example $7-2.)$ When this query is executed, there will be one row...

Group of answer choices

for each vendor

for each vendor with an average invoice total that$$s greater than $100$

for each vendor with a maximum invoice total that$$s greater than $100$

for each invoice with an invoice total that$$s greater than the average invoice total for the vendor and also greater than $100$