Mrftiinquisitive-crimson copy
    Updated 5 hours ago
    -- forked from inquisitive-crimson @ https://flipsidecrypto.xyz/studio/queries/a0241ef3-6933-4870-a674-dc824315d75b

    with tbl AS
    (
    SELECT
    creator_address AS "Address",
    COUNT(*) as "Contract deployed",
    RANK() OVER (ORDER BY COUNT(*) DESC) as deployer_rank
    FROM swell.core.dim_contracts
    GROUP BY 1
    )

    SELECT
    count (DISTINCT "Address") as "Unique contract deployer",
    sum ("Contract deployed") as "Contract deployed"
    from tbl


    Last run: about 5 hours agoAuto-refreshes every 12 hours
    Unique contract deployer
    Contract deployed
    1
    6355391
    1
    12B
    2s