Creating and Using a View to Provide Consolidated Information a. Create a view named work . T_Shirts containing the following columns: . Product_ID . Supplier_Name (formatted as $20.) . Product_Name . Price (Label it Retail Price.) Use data from the following tables: (Columns of interest are in parentheses.) . orion . Product_Dim (Product_ID, Product_Name, Supplier_Name) . orion. Price_list (Product_ID, Unit_Sales_Price) Select only those records where Product_Name includes the word T-Shirt. b. Write a query to display the data from your new work. T_Shirts view. Sort the report by Supplier_Name and Product_ID. Supply a useful title. C. Write a query using your new work. T_Shirts view to display Product_ID, Product_Name, and Price for all T-shirts priced less than $20.00. Sort the report by price. Supply a useful title