case

when contract_count <= 2 then '1至2个合约'

when contract_count > 2 and contract_count <= 5 then '3至5个合约'

when contract_count > 5 and contract_count <= 10 then '6至10个合约'

when contract_count > 10 and contract_count <= 15 then '11至15个合约'

when contract_count > 15 and contract_count <= 20 then '16至20个合约'

when contract_count > 20 and contract_count <= 30 then '21至30个合约'

when contract_count > 30 then '30个以上合约'

else '无合约数据'

end as "合约交互数量区间",

count(user) as "用户数量"

from

(select ft.FROM_ADDRESS as user, count(distinct fel.CONTRACT_ADDRESS) as contract_count

from monad.testnet.fact_transactions ft

join monad.testnet.fact_event_logs fel on ft.TX_HASH = fel.TX_HASH

where ft.TX_SUCCEEDED=true

group by ft.FROM_ADDRESS) as contract_counts

group by 1

order by 2 desc;