SELECT TX_HASH

from near.core.ez_token_transfers

where CONTRACT_ADDRESS='linear-protocol.near'

and MEMO='stake'

select case

when AMOUNT_USD>0 and AMOUNT_USD<10 then 'Below 10 $'

when AMOUNT_USD>=10 and AMOUNT_USD<=100 then '10~100 $'

when AMOUNT_USD>100 and AMOUNT_USD<=1000 then '100~1000 $'

when AMOUNT_USD>1000 and AMOUNT_USD<=10000 then '1000~10000 $'

when AMOUNT_USD>10000 then 'Up to 10000 $' end as dis_volume

,count(distinct FROM_ADDRESS)as stakers

,count(distinct TX_HASH) as stakes

from near.core.ez_token_transfers

where TX_HASH in (select TX_HASH from tab1)

and TO_ADDRESS='linear-protocol.near'

and dis_volume is not null

group by 1