The statement

CREATE VIEW Example1

AS

SELECT VendorName, SUM(InvoiceTotal) AS SumOfInvoices

FROM Vendors JOIN Invoices ON Vendors.VendorID = Invoices.VendorID

GROUP BY VendorName

ORDER BY VendorName;

(a) will fail because the GROUP BY clause isnt allowed in this view

(b) will fail because the column alias SumOfInvoices is invalid

(c) will fail because the ORDER BY clause isnt allowed in this view

(d) will succeed