distinct

purchaser,

COALESCE(INITCAP(REPLACE(l.label, '_', ' ')), 'Other') AS collection,

count(mint) as purchases

FROM solana.nft.fact_nft_sales s

LEFT JOIN solana.core.dim_labels l

ON l.address = s.mint

WHERE s.block_timestamp >= CASE WHEN '{{start_date}}' = '' THEN '2021-01-01' ELSE '{{start_date}}' END

AND s.block_timestamp <= CASE WHEN '{{end_date}}' = '' THEN CURRENT_DATE ELSE '{{end_date}}' END

AND s.succeeded

and collection ilike case when '{{collection_search}}' = '' then '{{collection}}' else '{{collection_search}}' end

group by 1,2

case when purchases > 1 then 'Multiple Purchases' else 'Single Purchaser' end as purchase_type,

count(distinct purchaser) as num_purchasers

from b0

group by 1