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;

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"