SELECT

c.address AS contract_address,

c.creator_address,

c.created_block_timestamp::DATE AS created_date

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'

SELECT

udc.contract_address,

udc.created_date,

udc.creator_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, udc.created_date, udc.creator_address

HAVING

COUNT(ft.tx_hash) >= 10