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 holdings, count(address) as count, sum(holdings) as sum

from last

group by 1