play_type,---name generall tabel

count(distinct tx_id) as number_of_tx,----count of transaction in colctions

sum(price) as volume_sales,---total volume sells

count(distinct seller) as count_of_sellers---count of sellers

from flow.core.fact_nft_sales join flow.core.dim_topshot_metadata ----I will combine two tables here

on flow.core.fact_nft_sales.nft_id = flow.core.dim_topshot_metadata.nft_id

where marketplace = 'A.c1e4f4f4c4257510.TopShotMarketV3'----addres contract

group by 1,2