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.