SELECT ProductName,

  'Product Type' =

  CASE

   WHEN UnitPrice > 30 THEN 'Expensive product'

 ELSE 'Inexpensive product'

 END

 FROM Products