SELECT

nft_from_address as address,

'-1' as flow

FROM polygon.core.ez_nft_transfers

where nft_address = lower('0x09421f533497331e1075fdca2a16e9ce3f52312b')

union all

select

nft_to_address as address,

'1' as flow

FROM polygon.core.ez_nft_transfers

where nft_address = lower('0x09421f533497331e1075fdca2a16e9ce3f52312b')

),

last as (select

address ,

sum(flow) as holdings

from raw

group by address

having holdings > 0

order by 2 desc)

select count (distinct address) as currentholder, sum(holdings) as totalNFT

from last