select min(BLOCK_TIMESTAMP::date) as date

,PURCHASER

from terra.core.fact_nft_sales

where CURRENCY='uluna'

and TX_SUCCEEDED='TRUE'

group by 2)

select date

,case

when date>='2022-12-11' and date<'2022-12-25' then 'TWO WEEKS BEFORE HOLIDAYS'

when date>='2022-12-25' and date<='2023-01-07' then 'DURING THE HOLIDAYS' end as time_status

,count(distinct PURCHASER) as new_buyers

from tab1

where date>='2022-12-11' and date<='2023-01-07'

group by 1,2