SELECT --*

to_address as User,

sum(amount) as Total_BLAST

from blast.core.ez_token_transfers

contract_address like '0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad'

and from_address like '0xf7be503166828fe8565c520d66645ac6a06bbdd7'

and symbol like 'BLAST'

group by 1

having total_Blast > 0.00001

)

select

case when Total_Blast between 0 and 100 then 'a. 0-100 BLAST'

when Total_Blast between 100 and 1000 then 'b. 100-1k BLAST'

when Total_Blast between 1000 and 10000 then 'c. 1k-10k BLAST'

when Total_Blast between 10000 and 100000 then 'd. 10k-100k BLAST'

when Total_Blast between 100000 and 1000000 then 'd. 100k-1M BLAST'

else 'e. > 1M BLAST' end as Holding_Distribuiton,

count(distinct user) ,

sum(Total_BLAST) as Balance

from tab1

group by 1