This statement will...

CREATE VIEW example$\_1$

AS

SELECT vendor$\_$name, SUM$($invoice$\_$total$)$ AS sum$\_$of$\_$invoices

FROM vendors JOIN invoices ON vendors.vendor$\_$id $=$ invoices.vendor$\_$id

GROUP BY vendor$\_$name

ORDER BY vendor$\_$name

Group of answer choices

fail because the ORDER BY clause isn$$t allowed

fail because the GROUP BY clause isn$$t allowed

succeed

fail because SUM function isn$$t allowed