What will happen when the statement below is run?

CREATE VIEW Example$1$

AS

SELECT VendorName, SUM$($InvoiceTotal$)$ AS SumOfInvoices

FROM Vendors v

JOIN Invoices i

ON v$.$VendorID $=$ i$.$VendorID

GROUP BY VendorName

ORDER BY VendorName;

Group of answer choices

it will fail because the GROUP BY clause isn$$t allowed with this code

it will fail because the column alias SumOfInvoices is invalid

it will fail because the ORDER BY clause isn$$t allowed with this code

it will succeed