select
date_trunc('week',block_timestamp) as weekly ,
case when program_id in ('cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ','cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ')
then 'minted via Metaplex Candy Machine'
else 'other'
end as type ,
count ( DISTINCT purchaser ) as unique_purchasers
from solana.fact_nft_mints
where block_timestamp::date >= '2021-12-01'
and succeeded = true
group by 1,2