with x as (

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 < 11 then '1~10Tx'

when txs > 10 and txs < 31 then '11~30Tx'

when txs > 30 and txs < 61 then '31~60Tx'

when txs > 60 and txs < 101 then '61~100Tx'

when txs > 100 then '>100Tx' end as "Activity rate"

x

GROUP by

2