select * from flipside_prod_db.crosschain.address_labels

where project_name = 'tornado cash'

),

token_transfers as (

select

from_address,

sum(amount_usd) as usd_volume,

count(distinct tx_hash) as number_of_transactions

from ethereum.core.ez_token_transfers

inner join tornado_addresses on address = to_address

where to_address in (select address from tornado_addresses)

and block_timestamp::date >= '2022-07-01'

and amount_usd is not null

group by from_address

order by number_of_transactions DESC)

select count(distinct from_address) as Count, usd_volume,

case

when usd_volume <= '1000' then 'Below 1000 User'

when usd_volume > '1000' and usd_volume <= '10000' then 'Below 10000 User'

when usd_volume > '10000' and usd_volume <= '100000' then 'Below 100000 User'

when usd_volume > '100000' and usd_volume <= '1000000' then 'Below 1000000 User'

when usd_volume > '1000000' then 'above 10000000 User'

end as Volume_category

from token_transfers

group by Volume_category, usd_volume