t1 as (

select

min(block_timestamp)::date as day,

minter as user

from terra.core.fact_nft_mints

group by user

select

day,

iff(year(day) = 2022, 'Before Chrismas', 'After Chrismas') as timespan,

count(distinct(user)) as new_users_count,

sum(new_users_count) over (partition by timespan order by day) as cumulative_new_users_count

from t1

where day between date('2023-01-01') - interval '2 weeks' and date('2023-01-01') + interval '2 weeks'

group by day, timespan

order by day