SELECT

c.address AS contract_address

FROM

berachain.testnet.dim_contracts c

JOIN

berachain.testnet.fact_transactions ft

ON

c.created_tx_hash = ft.tx_hash

WHERE

ft.origin_function_signature = '0x60806040'

t.interaction_count,

COUNT(*) AS contract_count

FROM (

SELECT

udc.contract_address,

COUNT(ft.tx_hash) AS interaction_count

FROM

user_deployed_contracts udc

LEFT JOIN

berachain.testnet.fact_transactions ft

ON

udc.contract_address = ft.to_address

GROUP BY

udc.contract_address

) t

GROUP BY

t.interaction_count

ORDER BY

t.interaction_count;