SELECT

DISTINCT contract,

count(DISTINCT tx_hash) as txs

from

external.tokenflow_starknet.decoded_transactions

where

CHAIN_ID = 'mainnet'

group by

1

count(DISTINCT contract) as wallets,

case

when txs >= 0

and txs < 5 then '0-4'

when txs > 4

and txs < 11 then '5-10'

when txs > 10

and txs < 26 then '11-25'

when txs > 25

and txs < 51 then '26-50'

when txs > 50

and txs < 101 then '51-100'

when txs > 100 then '>100'

end as "TXS"

x

GROUP by

2