distinct TX_HASH,

(raw_amount)/pow(10,18) as staked_amount

from ethereum_core.fact_token_transfers

where contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')

and from_address = '0x0000000000000000000000000000000000000000'

and raw_amount > 0

)

select

COUNT (DISTINCT TX_HASH) as num_tx,

when staked_amount < 0.1 then 'less than 0.1 ETH'

when staked_amount BETWEEN 0.1 and 1 then 'between 0.1-1 ETH'

when staked_amount BETWEEN 1 and 10 then 'between 1-10 ETH'

when staked_amount BETWEEN 10 and 100 then 'between 10-100 ETH'

when staked_amount BETWEEN 100 and 1000 then 'between 100-1000 ETH'

when staked_amount > 1000 then ' more than 1000 ETH'

end as distribution

from T1

group by 2