mohammadh1 ) Cryptopunk Sales and Traders(top 10 for nft count)
    Updated 2022-08-29
    with A as (select
    NFT_FROM_ADDRESS as seller,
    TOKENID
    from ethereum.core.ez_nft_transfers
    where(PROJECT_NAME = 'cryptopunks' and NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' or NFT_ADDRESS='0xb7f7f6c52f2e2fdb1963eab30438024864c313f6' and PROJECT_NAME='wrapped cryptopunks')),

    B as (select
    NFT_TO_ADDRESS as buyer,
    TOKENID
    from ethereum.core.ez_nft_transfers
    where (PROJECT_NAME = 'cryptopunks' and NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' or NFT_ADDRESS='0xb7f7f6c52f2e2fdb1963eab30438024864c313f6' and PROJECT_NAME='wrapped cryptopunks'))

    select
    buyer as holder,
    count(distinct B.TOKENID) - count(distinct A.TOKENID) as nft_count
    from A join B on A.seller=B.buyer
    where HOLDER !='0x0000000000000000000000000000000000000000'
    group by holder
    order by nft_count desc
    limit 10

    Run a query to Download Data