with tbl_mint as (select distinct mint from solana.dim_nft_metadata where token_name='Lightning OG')
,tbl_PURCHASER as (select * from solana.fact_nft_sales
where
(program_id='MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8' or program_id='M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
and block_timestamp::date >= '2022-02-05'
and mint in (select distinct mint from tbl_mint)
)
select count(distinct PURCHASER) as p,block_timestamp::date as d from tbl_PURCHASER
group by d
order by d