count(DISTINCT tx_id) as sales,

COUNT(DISTINCT PURCHASER) as buyers,

COUNT(DISTINCT SELLER) as sellers,

sum(sales_amount) as sales_volume,

avg(sales_amount) as avg_sales_price

FROM solana.core.fact_nft_sales

LEFT outer JOIN solana.core.dim_nft_metadata

ON solana.core.fact_nft_sales.mint = solana.core.dim_nft_metadata.mint

WHERE token_name LIKE '{{collection}}' --IN ('Degen Apes', 'DeGods', 'Catalina Whale Mixer', 'Primates')