case

when txs <= 2 then '1至2次交易'

when txs > 2 and txs <= 5 then '3至5次交易'

when txs > 5 and txs <= 10 then '6至10次交易'

when txs > 10 and txs <= 20 then '11至20次交易'

when txs > 20 and txs <= 50 then '21至50次交易'

when txs > 50 and txs <= 100 then '51至100次交易'

when txs > 100 and txs <= 500 then '101至500次交易'

when txs > 500 and txs <= 1000 then '501至1000次交易'

when txs > 1000 then '1000次以上交易'

else '无交易数据' end as "TX交易数量区间",

count(user) as "用户数量",

round(count(user) * 100.0 / (select count(DISTINCT FROM_ADDRESS) from monad.testnet.fact_transactions where TX_SUCCEEDED=true), 2) as "% 百分比"

from

(select FROM_ADDRESS as user, count(*) as txs

from monad.testnet.fact_transactions

where TX_SUCCEEDED=true

group by 1) as tx_counts

group by 1

order by 2 desc