--People who hold a certain number of nft
with punk1 as (
SELECT
tokenid ,
nft_from_address as sender
FROM ethereum.core.ez_nft_transfers
where project_name = 'cryptopunks'),
punk2 as (
select
tokenid ,
nft_to_address as receiver
FROM ethereum.core.ez_nft_transfers
where project_name = 'cryptopunks')
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
where HOLDERS is not null
group by 1 having num_nfts <> 0
order by 2 desc
offset 1 rows FETCH first 10000 rows only