write a statement to create a view called product$\_$sales$\_$totals which will group sales data by product and year. Columns should include product$\_$id$,$ year, product$\_$sales, and gear$\_$sales. The gear$\_$salescolumn will contain the total sales for the "Gear$-$Large" or the total sales for "Gear $-$ Small" products, depending on the product$\_$id$.$ In the case that the product is neither "Gear$-$Large" or "Gear$-$Small", the value for gear$\_$sales should be $0.($The data should be generated by an expression, and it is ok to use the product$\_$id values in the expression$).$ To accomplish this, you need a case statement. The product$\_$sales column should be a sum of sales for the particular product$\_$id and year, regardless of what kind of product it is $($including gears$).$