תרגול SQL מספר 1034 – מניפולציות על לקוחות

select

   customers.*,
   case when customers.customer_id is null then 1 else 0 end as ind_null,

   case

          when sum_orders<100 then 'Small'

          when sum_orders>=100 and sum_orders<500  then 'meduim'

          when sum_orders>=500 then 'big'

   end as customer_group

from
   e_commerce.customers