marketplace,

count(distinct tx_id) as sales_count,

count(distinct purchaser) as buyers_count,

count(distinct seller) as sellers_count,

count(distinct mint) as nfts_count,

sum(sales_amount) as volume,

avg(sales_amount) as avg_volume,

median(sales_amount) as median_sales_amount,

min(sales_amount) as minimum_sales_amount,

max(sales_amount) as maximum_sales_amount

from solana.core.fact_nft_sales

where succeeded = 1

and block_timestamp > current_date - 90

group by 1