select case

when VALUE>0 and VALUE<=50 then 'One Ticket'

when VALUE>50 and VALUE<=500 then '2~10 Ticket'

when VALUE>500 and VALUE<=5000 then '11~100 Ticket'

when VALUE>5000 then 'Up to 100 Ticket' end as dis_ticket

,count(distinct FROM_ADDRESS) as purchasers

from ronin.core.fact_transactions

where TO_ADDRESS='0xbe21424c284654c8b4b1d1b11e732bd1e654b3c4'

and ORIGIN_FUNCTION_SIGNATURE='0xf1151e76'

group by 1

order by 1