select date_trunc('week',BLOCK_TIMESTAMP)as week,

MARKETPLACE,count(distinct MINT)as sold_nft_count

,count(distinct PURCHASER) as unique_buyers,count(distinct SELLER)as unique_sellers

,count(distinct TX_ID)as sales_count_volume,max(SALES_AMOUNT)as sales_volume_sol

from solana.core.fact_nft_sales

where (MARKETPLACE='coral cube' or MARKETPLACE='hyperspace')

and SUCCEEDED='TRUE'

group by 1,2

order by 1,2)

select MARKETPLACE

,max(sales_count_volume)as MAX

,min(sales_count_volume)as MIN

,median(sales_count_volume)as MED

,avg(sales_count_volume)as AVG

from tab1

group by 1