SELECT
    T02.[LastName]
   ,T02.[FirstName]
	,T03.[EnglishProductName]
	,T05.[EnglishProductCategoryName]
	,T04.[EnglishProductSubCategoryName]
	,T01.[OrderDate]
FROM
   [dbo].[FactInternetSales] T01
	LEFT JOIN [dbo].[DimCustomer] T02
	ON
	  T01.[CustomerKey] = T02.[CustomerKey]
	LEFT JOIN [dbo].[DimProduct] T03
	ON
	  T01.[ProductKey] = T03.[ProductKey]
	LEFT JOIN [dbo].[DimProductSubcategory] T04
	ON
	  T03.[ProductSubcategoryKey] = T04.[ProductSubcategoryKey]
	LEFT JOIN [dbo].[DimProductCategory] T05
	ON
	  T05.[ProductCategoryKey] = T04.[ProductCategoryKey];