,max(SALES_AMOUNT)as MAX

,min(SALES_AMOUNT) as MIN

,median(SALES_AMOUNT) as MED

,avg(SALES_AMOUNT) as AVG

from solana.core.fact_nft_sales

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

and SUCCEEDED='TRUE'

group by 1