SELECT

tokenid ,

nft_from_address as sender

FROM ethereum.core.ez_nft_transfers

where project_name = 'cryptopunks' and block_timestamp >= '2023-01-01'),

punk2 as (

select

tokenid ,

nft_to_address as receiver

FROM ethereum.core.ez_nft_transfers

where project_name = 'cryptopunks' and block_timestamp >= '2023-01-01')

select

receiver as Holders ,

count (distinct p2.tokenid) - count (distinct p1.tokenid) as num_nfts

from punk1 p1

full outer join punk2 p2

on p1.sender = p2.receiver

and p1.tokenid = p2.tokenid

group by 1 having num_nfts <> 0

order by 2 desc

offset 1 rows FETCH first 10 rows only