Base as (

SELECT

Buys_Base.buyer as wallet,

Buys_Base.team,

Buys_Base.counts - Sale_Base.counts as Hold_Count

from

(select

buyer,

team,

count(distinct tx_id) as counts

from

flow.core.EZ_NFT_SALES NFTS

join flow.core.dim_topshot_metadata TopShop on NFTS.nft_id = TopShop.nft_id

where

TX_SUCCEEDED = 'TRUE'

group by

1,

2)Buys_Base

left join

(select

seller,

team,

count(distinct tx_id) as counts

from

flow.core.EZ_NFT_SALES NFTS

join flow.core.dim_topshot_metadata TopShop on NFTS.nft_id = TopShop.nft_id

where

TX_SUCCEEDED = 'TRUE'

group by

1,

2)Sale_Base

on Buys_Base.buyer = Sale_Base.seller

and Buys_Base.team = Sale_Base.team

having