select
  id,
  case when order_count < 50
  then 1
  else 0
  end as is_small_customer
from customer