SELECT

IFF(MARKETPLACE IN ('magic eden v1','magic eden v2'),'Magic Eden',IFF(MARKETPLACE='hadeswap','HadeSwap','Other')) AS Marketplace,

SUM(SALES_AMOUNT) AS Sales_amount,

COUNT(DISTINCT Purchaser) AS Purchaser,

Count(*) AS Sales

FROM solana.core.fact_nft_sales

WHERE SUCCEEDED = 'TRUE'

GROUP BY 1)

Marketplace,

Sales_amount,

Purchaser,

Sales,

Sales_amount/Sales As AVG_sales_amount,

Sales_amount/purchaser AS AVG_SPENT_BY_PURCHASER,

Sales/purchaser AS avg_sales_per_purchaser

FROM t1

order by 1