Voicedrelieved-teal
    Updated 2024-10-25
    SELECT
    --count (DISTINCT tx_hash) as "Contract deploy transaction",
    count (DISTINCT to_address) as "Contract deployed",
    count (DISTINCT from_address) as "Unique contract deployer"
    from berachain.testnet.fact_traces
    where type like '%CREATE%'
    AND to_address IS NOT NULL
    AND input IS NOT NULL
    AND input != '0x'
    QueryRunArchived: QueryRun has been archived