Create a view named product_summary that uses the view you created in question 4. This view should return summary information about each product. Each row should include product_name, order_count (the number of times the product has been ordered) and order_total (the total sales for the product).

Following are the Query to this question:

/*creating view product_summary */

CREATE VIEW product_summary AS

SELECT product_name, COUNT (order id) As order_count,

/* selects columns names */

SUM(item_total) AS order_total  /* add values */

FROM order_item_products   /* table name order_item_products*/

GROUP BY product name;

Explanation:

Creating view description can be described as follows:

go to edit profile, preferences, then choose level and select the desired choice.