freemartianمجموعه‌دارها
    Updated 2024-05-03
    -- forked from Canvas Set Holders @ https://flipsidecrypto.xyz/edit/queries/8dac22a0-8762-4cf9-a471-20f169a3dcec

    with transfers AS (
    select
    nft_to_address AS owner,
    count(distinct tokenid) as Number_of_tokens_owned
    from base.nft.ez_nft_transfers
    where nft_address = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'
    group by 1)

    select
    Number_of_tokens_owned,
    count(owner) as number_of_holder,
    (count(owner) * 100.0 / (select count(DISTINCT owner) from transfers)) AS percentage_of_holders
    from transfers
    group by 1


    QueryRunArchived: QueryRun has been archived