case

when (raw_amount/1e18) < 0.001 then 'O.less then 0.001 $matic deposit'

when (raw_amount/1e18) between 0.001 and 0.01 then 'N.btw 0.001 and 0.01 $matic deposit'

when (raw_amount/1e18) between 0.01 and 0.1 then 'M.btw 0.01 and 0.1 $matic deposit'

when (raw_amount/1e18) between 0.1 and 0.3 then 'L.btw 0.1 and 0.3 $matic deposit'

when (raw_amount/1e18) between 0.3 and 0.5 then 'K.btw 0.3 and 0.5 $matic deposit'

when (raw_amount/1e18) between 0.5 and 0.75 then 'J.btw 0.5 and 0.75 $matic deposit'

when (raw_amount/1e18) between 0.75 and 1 then 'I.btw 0.75 and 1 $matic deposit'

when (raw_amount/1e18) between 1 and 2 then 'H.btw 1 and 2 $matic deposit'

when (raw_amount/1e18) between 2 and 5 then 'G.btw 2 and 5 $matic deposit'

when (raw_amount/1e18) between 5 and 10 then 'F.btw 5 and 10 $matic deposit'

when (raw_amount/1e18) between 10 and 15 then 'E.btw 10 and 15 $matic deposit'

when (raw_amount/1e18) between 15 and 30 then 'D.btw 15 and 30 $matic deposit'

when (raw_amount/1e18) between 30 and 50 then 'C.btw 30 and 50 $matic deposit'

when (raw_amount/1e18) between 50 and 100 then 'B.btw 50 and 100 $matic deposit'

else 'A.more then 100 $matic deposit'

end as eth_distribution ,

count (distinct tx_hash) as total_transaction ,

row_number() over (order by total_transaction desc) as rank

from polygon.core.fact_token_transfers

where from_address = '0x0000000000000000000000000000000000000000'

and contract_address =lower('0x3aD736904E9e65189c3000c7DD2c8AC8bB7cD4e3')

group by 1