case

when contract_address = '0x3a58a54c066fdc0f2d55fc9c89f0415c92ebf3c4' then 'Lido: stMATIC'

when contract_address = '0x7ed6390f38d554b8518ef30b925b46972e768af8' then 'ClayStack: csMATIC'

when contract_address = '0x03a97594aa5ece130e2e956fc0ced2fea8ed8989' then 'Ankr: aMATICb'

when contract_address = '0x3ad736904e9e65189c3000c7dd2c8ac8bb7cd4e3' then 'Stader: MaticX'

else 'others'

end as platform,

case

when raw_amount/1e18 <= 1 then 'a. 0-1 Matic'

when raw_amount/1e18 <= 10 then 'b. 1-10 Matic'

when raw_amount/1e18 <= 100 then 'c. 10-100 Matic'

when raw_amount/1e18 <= 1000 then 'd. 100-1,000 Matic'

when raw_amount/1e18 <= 10000 then 'e. 1,000-10,000 Matic'

else 'f. more than 10,000 Matic' end as dis, count(distinct tx_hash) as "count"

from polygon.core.fact_token_transfers

where platform != 'others' and from_address = '0x0000000000000000000000000000000000000000'

group by 1, 2