AA as(

select from_address as user, from_address as contract, to_address as pool, amount as amount, contract_address, block_timestamp from blast.core.ez_token_transfers union all

select to_address as user, to_address as contract, from_address as pool, 0 - amount as amount, contract_address, block_timestamp from blast.core.ez_token_transfers ),

BB as(

select user, contract_address, sum(amount) as amount, min(block_timestamp) as time

from AA

where contract_address = '0x42e12d42b3d6c4a74a88a61063856756ea2db357'

and pool in ('0xfa1fdcf4682b72e56e3b32ff1aba7afcd5e1c7a8')

group by 1,2

having sum(amount) > 0

),

CC as(

select rank() over(order by amount desc) as rank, amount

from BB )

select

case when rank <= 10 then 'TOP 01-10'

when rank <= 100 then 'TOP 10-100'

else 'OTHER' end as tier,

sum(amount) as amount

from CC

group by 1

order by 1