select
team,
sum (PRICE) as volume
from flow.core.fact_nft_sales
join flow.core.dim_topshot_metadata
using (NFT_ID )
where block_timestamp between '2022-05-17' and '2022-05-29'
and NFT_COLLECTION = 'A.c4ff83bddcf08500.TopshotData'or
NFT_COLLECTION='A.c1e4f4f4c4257510.TopShotMarketV3'or
NFT_COLLECTION='A.0b2a3299cc857e29.TopShot'
group by team
order by volume desc
limit 5