SELECT
    CUST.[LastName]
   ,CUST.[FirstName]
	,P.[EnglishProductName]
	,PC.[EnglishProductCategoryName]
	,PSC.[EnglishProductSubCategoryName]
	,[IS].[OrderDate]
FROM
   [dbo].[FactInternetSales] [IS]
	LEFT JOIN [dbo].[DimCustomer] CUST
	ON
	  [IS].[CustomerKey] = CUST.[CustomerKey]
	LEFT JOIN [dbo].[DimProduct] P
	ON
	  [IS].[ProductKey] = P.[ProductKey]
	LEFT JOIN [dbo].[DimProductSubcategory] PSC
	ON
	  P.[ProductSubcategoryKey] = PSC.[ProductSubcategoryKey]
	LEFT JOIN [dbo].[DimProductCategory] PC
	ON
	  PC.[ProductCategoryKey] = PSC.[ProductCategoryKey];