origin_from_address as user,

count(distinct tx_hash) as tx_count

from

ronin.core.fact_event_logs

where

contract_address in ('0x3825ff6b6ad0f460660547e5890425ee821bd02c', '0xd887014121ddbad4494093689997125dde30612a')

group by

user

select

case

when tx_count < 2 then 'A. 1'

when tx_count < 4 then 'B. 2-3'

when tx_count < 8 then 'C. 4-7'

when tx_count < 16 then 'D. 8-15'

when tx_count < 32 then 'E. 16-31'

when tx_count < 64 then 'F. 32-63'

when tx_count < 128 then 'G. 64-127'

else 'more than 128' end as dis,

count(distinct user) as user_count,

100.0 * count(distinct user) / sum(count(distinct user)) over () as user_count_percentage

from per_user

group by 1