use Northwind
select
ProductName,
UnitPrice,
UnitsInStock,
UnitsOnOrder,
ReorderLevel,
Zabraknie = CEILING(ABS((ReorderLevel+UnitsOnOrder)-UnitsInStock)*1.25),
CEILING(ABS((ReorderLevel+UnitsOnOrder)-UnitsInStock)*1.25)*UnitPrice as Koszt,

 CASE   
         WHEN CEILING(ABS((ReorderLevel+UnitsOnOrder)-UnitsInStock)*1.25)*UnitPrice Between 0 and 1000 THEN 'ok'  
         WHEN CEILING(ABS((ReorderLevel+UnitsOnOrder)-UnitsInStock)*1.25)*UnitPrice Between 1000 and 1999 THEN 'niewesolo'  
         WHEN CEILING(ABS((ReorderLevel+UnitsOnOrder)-UnitsInStock)*1.25)*UnitPrice Between 2000 and 2999  THEN 'drogo'  
         WHEN CEILING(ABS((ReorderLevel+UnitsOnOrder)-UnitsInStock)*1.25)*UnitPrice Between 3000 and 999999 THEN 'masakra'  
         ELSE 'ni ma kasy'  
  END  as Kwalifikacja



from
Products

order by
Kwalifikacja
desc