A view of sales per product

This lesson is part of solulu Pro

Create a view named total_sales that shows, for each product that has been sold, product_name, category and total_sales_amount (the sum of its sales' total_price).