select *

from flow.core.fact_nft_sales

where tx_succeeded ='true' and nft_collection='A.329feb3ab062d289.RaceDay_NFT'),

crossover as (select t1.nft_collection as project_name,

count(distinct t2.buyer) as crossover_buyer

from flow.core.fact_nft_sales t1

right join topshot t2

on t1.buyer=t2.buyer

where t1.tx_succeeded ='true' and t1.nft_collection != 'A.329feb3ab062d289.RaceDay_NFT'

group by 1

order by 2 desc)

select t22.contract_name as nft_project, t11.crossover_buyer

from crossover t11

join flow.core.dim_contract_labels t22

on t11.project_name = t22.event_contract

order by 2 desc