case

when txs = 1 then '1. 1 tx'

when txs > 1 and txs <= 5 then '2. 2 ~ 5 txs'

when txs > 5 and txs <= 10 then '3. 6 ~ 10 txs'

when txs > 10 and txs <= 20 then '4. 11 ~ 20 txs'

when txs > 21 and txs <= 50 then '5. 21 ~ 50 txs'

when txs > 50 then '6. Over 50 txs'

end as type,

count(distinct CONTRACT) as users

from (

select

distinct CONTRACT,

count(distinct tx_hash) as txs,

count (Distinct TIMESTAMP::Date) as active_days

from external.tokenflow_starknet.decoded_transactions where CHAIN_ID = 'mainnet'

group by 1)

group by 1

having type is not null

order by 1 asc