WITH secondary_sale AS (
SELECT block_timestamp::date as date, tx_id, n.mint, purchaser, SALES_AMOUNT, project_name
FROM solana.fact_nft_sales n LEFT OUTER JOIN solana.dim_nft_metadata m ON n.mint = m.mint
WHERE SUCCEEDED = 'TRUE' and project_name = 'DeGods'
)
, buyers as (
SELECT purchaser, COUNT(DISTINCT mint) as num_mints
FROM secondary_sale
GROUP BY 1
ORDER BY 2 DESC
)
SELECT num_mints as "Num NFTs Bought", COUNT(DISTINCT purchaser) as "Num Buyers"
FROM buyers
GROUP BY 1