buyer

from flow.core.fact_nft_sales

where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

and tx_succeeded = 'TRUE'

group by 2),

top_shot as (select min(block_timestamp) as first_purchase,

buyer

from flow.core.fact_nft_sales

where nft_collection = 'A.0b2a3299cc857e29.TopShot'

and tx_succeeded = 'TRUE'

group by 2)

select date_trunc('day', first_purchase) as day,

'NFL All Day' as projects,

count(distinct(buyer)) as buyer_count,

when day >= '2022-09-09 00:00:00.000' then 'Start of Regular Season'

else 'Before Regular Season'

end as season

from all_day

group by 1