Sales by country

[Santosh Gadila]

SELECT        DimProductCategory.EnglishProductCategoryName, DimProductSubcategory.EnglishProductSubcategoryName, SUM(FactResellerSales.SalesAmount)

                         AS SalesAmount, DimSalesTerritory.SalesTerritoryGroup, DimSalesTerritory.SalesTerritoryCountry, DimProduct.EnglishProductName

FROM            DimSalesTerritory INNER JOIN

                         FactResellerSales ON DimSalesTerritory.SalesTerritoryKey = FactResellerSales.SalesTerritoryKey INNER JOIN

                         DimProduct ON FactResellerSales.ProductKey = DimProduct.ProductKey INNER JOIN

                         DimProductSubcategory INNER JOIN

                        DimProductCategory ON DimProductSubcategory.ProductCategoryKey = DimProductCategory.ProductCategoryKey ON

                         DimProduct.ProductSubcategoryKey = DimProductSubcategory.ProductSubcategoryKey

Where DimSalesTerritory.SalesTerritoryGroup = @STGroup

GROUP BY DimProductCategory.EnglishProductCategoryName, DimProductSubcategory.EnglishProductSubcategoryName, DimProduct.EnglishProductName,

                         DimSalesTerritory.SalesTerritoryGroup, DimSalesTerritory.SalesTerritoryCountry