select EVENT_CONTRACT

from flow.core.dim_contract_labels

where contract_name ilike '%TopShot%'

group by 1

),

Top10_during_conference as (select

team,

sum (PRICE) as sales_volume

from flow.core.fact_nft_sales join flow.core.dim_topshot_metadata using ( NFT_ID )

where block_timestamp::date between '2022-05-17' and '2022-05-30'

and NFT_COLLECTION in (select EVENT_CONTRACT from NBA_nfts )

group by 1 order by sales_volume desc limit 5

select * from Top10_during_conference