SELECT sum(SALES_AMOUNT) AS TotalPrice ,

COUNT(DISTINCT TX_ID) AS tx_count,

COUNT(DISTINCT PURCHASER) AS buyer_count,

COUNT(DISTINCT SELLER) AS seller_count,

COUNT(DISTINCT TOKEN_ID) as nft_count,

min(SALES_AMOUNT) AS min,

max(SALES_AMOUNT) AS max,

median(SALES_AMOUNT) AS median,

avg(SALES_AMOUNT) AS avg

FROM solana.core.fact_nft_sales n join solana.dim_nft_metadata m on m.MINT = n.MINT

WHERE CONTRACT_NAME = 'Cets On Creck'

AND SALES_AMOUNT is not null AND SUCCEEDED='TRUE'