Aliases

USE AdventureWorksDW2019MSDS

SELECT
p.EnglishProductName AS [Product Name]
FROM dw.DimProduct p
WHERE 1 = 1
AND IsMostRecentRecord = 1