SELECT

nft_from_address as address,

'-1' as flow

FROM ethereum.core.ez_nft_transfers

where nft_address = lower('0x9674739124d69d555712a30e0a44de648f494219')

union all

select

nft_to_address as address,

'1' as flow

FROM ethereum.core.ez_nft_transfers

where nft_address = lower('0x9674739124d69d555712a30e0a44de648f494219')

),

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