SELECT ProductID 'Identyfikator', [Name] 'Nazwa', ListPrice 'Cena sprzedaży', StandardCost 'Cena zakupu', color 'Kolor',
(ListPrice-StandardCost) AS PROFIT,
((ListPrice-StandardCost)/StandardCost)*100 AS MARGIN,
IIF(SellEndDate is null, 'true', 'false') AS ACTIVE,
IIF(WeightUnit = 'LB', Weight*453.6, Weight) AS UNIWEIGHT,
case  when (ListPrice > 0 and ListPrice < 100) Then 'LOW'
  FROM [AdventureWorksLT_TI].[SalesLT].[Product]