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

)

SELECT count(DISTINCT contract) as wallets, case

when txs = 1 then 'A) Only 1 Transaction'

when txs > 1 and txs < 11 then 'B) Between 2~10 Transactions'

when txs > 10 and txs < 51 then 'C) Between 11~50 Transactions'

when txs > 50 and txs < 101 then 'D) Between 51~100 Transactions'

when txs > 110 and txs < 500 then 'E) Between 101~500 Transactions'

when txs > 500 then 'F) More than 500 Transactions' end as "Activity rate"

from x

GROUP by 2