Code example $6-2$

WITH Top$5$ AS

$($SELECT TOP $5$ VendorID, AVG$($InvoiceTotal$)$ AS AvgInvoice

FROM Invoices

GROUP BY VendorID

ORDER BY AvgInvoice DESC$)$

SELECT Invoices.VendorID, MAX$($Invoices$.$InvoiceTotal$)$ AS LargestInvoice

FROM Invoices JOIN Top$5$

ON Invoices.VendorID $=$ Top$5.$VendorID

GROUP BY Invoices.VendorID

ORDER BY LargestInvoice DESC;

$($Please refer to code example $6-2.)$ How many rows will there be in the result table when this query is executed?

Group of answer choices

$5$

$6$

$1$

Unknown