sum(price) as volume,

avg(price) as avg_price,

median(price) as median_price,

count(DISTINCT tx_id) as sales,

count(DISTINCT buyer) as buyers,

(sum(price))/(count(DISTINCT buyer)) as avg_vol_per_buyer,

(count(DISTINCT buyer))/373 as avg_buyer_per_day,

(count(DISTINCT tx_id))/373 as avg_sales_per_day,

(count(DISTINCT tx_id))/(count(DISTINCT buyer)) as avg_sales_per_buyer

FROM flow.core.ez_nft_sales

WHERE NFT_COLLECTION LIKE '%RaceDay%'