Updated 2025-01-26
    SELECT
    contract_count_category,
    COUNT(origin_from_address) AS address_count
    FROM (
    SELECT
    origin_from_address,
    COUNT(DISTINCT contract_address) AS distinct_contract_count,
    CASE
    WHEN COUNT(DISTINCT contract_address) = 1 THEN '1 contract'
    WHEN COUNT(DISTINCT contract_address) BETWEEN 2 AND 5 THEN '2-5 contracts'
    WHEN COUNT(DISTINCT contract_address) BETWEEN 6 AND 10 THEN '6-10 contracts'
    WHEN COUNT(DISTINCT contract_address) BETWEEN 11 AND 20 THEN '11-20 contracts'
    ELSE 'More than 20 contracts'
    END AS contract_count_category
    FROM flow.core_evm.fact_event_logs
    GROUP BY
    origin_from_address
    ) AS categorized
    GROUP BY
    contract_count_category;
















    Last run: 20 days ago
    CONTRACT_COUNT_CATEGORY
    ADDRESS_COUNT
    1
    1 contract704
    2
    More than 20 contracts108
    3
    11-20 contracts218
    4
    2-5 contracts1251
    5
    6-10 contracts310
    5
    121B
    1s