Question 10 Save Answer Adventure Works Cycle Data Warehouse: The Adventure Works Cycle Data Warehouse is available for your use in the course database server (follow the steps in Tutorial 2 to access...

Extracted text: Question 10 Save Answer Adventure Works Cycle Data Warehouse: The Adventure Works Cycle Data Warehouse is available for your use in the course database server (follow the steps in Tutorial 2 to access the data warehouse (named "aw") and review the course Handout 8, slides 13-18 for the description). You are required to complete the following MYSQL statement to perform this task: For each of the product category, display (in this order) the category name (in English), the total number of unique products belonging to the category, the total number of sales orders of the category, and the total sales amount in the category. (enter only one alphanumeric string in each blank below; do not enter space or other unnecessary symbols; assume that all strings are non-case sensitive. Hint: The sum of all the total sales should be equal to the sum of all the total sales in Question 8). SELECT c. AS 'Product Category', р. ) AS Num_Products, (f. ) AS Num_Orders, (f. ) AS Total_Sales FROM C, P. S, f WHERE p. =s. AND s. =c. AND f. =p. c.


Extracted text: FactInternetSales DimPromotion Productkey DimCustomer 8 PromotionKey OrderDatekey 7 Customerkey PromotionAlternatekey DueDatekey Geographykey ShipDatekey Customer Alternatekey CustomerKey Promotionkey Currencykey SalesTerritorykey DimDate 9 SalesOrderNumber 9 Datekey pod SalesOrderLineNumber FulDateAternatekey RevisionNumber DimGeography OrderQuantity V Geographykey UnitPrice SalesTerritorykey ExtendedAmount UnitPriceDiscountPct DiscountAmount ProductStandardCost DimCurrency 7 Currencykey TotalProductCost SalesAmount CurrencyAlternatekey ТахАmt DimSalesTerritory 7 SalesTerrikoryKey Freight CarrierTrackingNumber CustomerPONumber SalesTerrkoryAlternate... OrderDate DimProduct DueDate 7 Productkey ShipDate ProductAlternatekey ProductSubcategorykey StartDate FactInternetSalesRea 9 SalesOrderNumber T| SalesOrderLineNumber DimProductSubcategc DimProductCategory 9 ProductSubcategoryKey ProductCategorykKey ProductSubcategoryAlt... ProductCategoryAkern.. 7 SalesReasonkey ProductCategorykey