SELECT

tokenid ,

nft_from_address as sender

FROM ethereum.core.ez_nft_transfers

where project_name = 'terraforms'),

TERRAFORMS2 as (

select

tokenid ,

nft_to_address as receiver

FROM ethereum.core.ez_nft_transfers

where project_name = 'terraforms')

select

receiver as Holders ,

count (distinct T2.tokenid) - count (distinct T1.tokenid) as num_nfts

from TERRAFORMS1 T1

full outer join TERRAFORMS2 T2

on T1.sender = T2.receiver

and T1.tokenid = T2.tokenid

group by 1 having num_nfts <> 0

order by 2 desc

offset 1 rows FETCH first 10 rows only