a as (

select

nft_to_address as wallets,

'1' as flag

FROM base.nft.ez_nft_transfers

where (nft_address =lower('0xbdb1a8772409a0c5eeb347060cbf4b41dd7b2c62') )

union all

SELECT

nft_from_address as wallets,

'-1' as flag

FROM base.nft.ez_nft_transfers

where (nft_address =lower('0xbdb1a8772409a0c5eeb347060cbf4b41dd7b2c62'))

),

b as (

select wallets , sum(flag) as nfts

from a

group by 1

having nfts > 0

order by 2 desc

select

count(distinct wallets) as "Holders" ,

sum(nfts) as "Number of NFTS",

round(avg(nfts),1) as "Average Holding"

from b