Assuming the SELECT statement below is a proper query, which is true regarding the following statement?
CREATE VIEW example AS
SELECT vendor_name, SUM(invoice_total) AS "Invoice Sum"
FROM vendors JOIN invoices ON vendors.vendor_id = invoices.vendor_id
GROUP BY vendor_name ORDER BY vendor_name; (Points : 4)
(A) It will fail because the GROUP BY clause is not allowed in a view.
(B) It will fail because SUM function is not allowed in a view.
(C) It will fail because ORDER BY clause is not allowed in a view.
(D) It will succeed.