distinct BUYER as TS_address

from flow.core.fact_nft_sales

where TX_SUCCEEDED='TRUE'

and tx_id is not NULL

and NFT_COLLECTION='A.0b2a3299cc857e29.TopShot')

select

distinct NFT_COLLECTION,

count(distinct buyer) as crossover

from flow.core.fact_nft_sales

where TX_SUCCEEDED='TRUE'

and tx_id is not NULL

and buyer in (select TS_address from tb1)

and NFT_COLLECTION!='A.0b2a3299cc857e29.TopShot'

group by 1 order by 2 desc limit 10