select OrderID, Amount,
 case
  when Amount > 600 then 'Large'
  when Amount > 300 then 'Medium'
  when Amount > 50 then 'Small'
 end as "Order Size"
from Orders