select ORIGIN_ADDRESS ,count(distinct tx_id) as transactions

from ethereum.udm_events

where (TO_label ilike'%uniswap%' or from_label ilike'%uniswap%') and block_timestamp >'2021-12-01'

group by 1 having transactions>2

)

select

count(distinct ORIGIN_ADDRESS) as users,

case when transactions between 1 and 5 then '1-5'

when transactions between 5 and 10 then '5-10'

when transactions between 10 and 50 then '10-50'

when transactions between 50 and 100 then '50-100'

when transactions between 100 and 500 then '100-500'

when transactions between 500 and 1000 then '500-1000'

when transactions>1000 then 'more than 1000' end as tt

from a

group by 2 having tt is not null