I need guidance on using a SELECT statement with the view created in problem #4. I am getting an error message in its current form.

B |?? SCHEMAS Limit to 1000 rows Q Filter objects 56 SELECT* 57 58 59 60 61 62 63 64 product has been ordered) and order total (the total sales for the product).7 65 66 CREATE OR REPLACE VIEW product summary AS 67 68 69 70 71 72 SELECT * 73 74 75 76 order items FROM order_item_products; ?b Columns ? item_id Create a view named product summary that uses the view you created in exercise 3 This view should return summary information about each product Each row should include product_name, order_count (the number of times the order id ? product_id item_price discount_amount ? quantity Indexes Foreign Keys Triggers SELECT product_name, SUM(quantity) AS order_count, SUM(item_total) AS total_sales FROM order_item_products ORDER BY product_name; FROM product summary; orders products ?CD| Columns 78 79 80 81 82 83 84 85 86 87 Write a SELECT statement that uses the view that you created in exercise 4 to get total sales for the five best selling products. SELECT total sales FROM product_summary GROUP BY product_name; product_id ? category_id ? product-code ? product_name Object Info Session 89 90 Column: item_price Definition 92 item_price decimal(10,2) 100% 1:72