WITH sales AS (
SELECT
a.sales_amount,
a.tx_id,
b.project_name
FROM solana.core.fact_nft_sales as a JOIN solana.core.dim_nft_metadata as b ON a.mint = b.contract_address
WHERE marketplace IN ('yawww', 'solanart') AND block_timestamp > CURRENT_DATE - 90
)
SELECT project_name, count(DISTINCT tx_id), sum(sales_amount)
FROM sales
GROUP BY project_name