zyroqhold
    Updated 2024-12-06
    WITH nft_transfers AS (
    SELECT
    token_id,
    TO_ADDRESS AS current_holder
    FROM
    near.nft.fact_nft_transfers
    WHERE
    CONTRACT_ADDRESS = 'tinkerunion_nft.enleap.near'
    ),

    unique_holders AS (
    SELECT DISTINCT
    current_holder
    FROM
    nft_transfers
    )

    SELECT
    COUNT(*) AS total_nft_holders
    FROM
    unique_holders;

    QueryRunArchived: QueryRun has been archived