select

tx_sender as wallet_address,

min(block_timestamp)::date as creation_date

from terra.core.fact_transactions

group by wallet_address

select

creation_date as "Days",

count(distinct wallet_address) as "Number of New User",

case

when creation_date >= '2022-12-12' and creation_date < '2022-12-25' then 'Before Christmas Holidays'

when creation_date >= '2022-12-25' and creation_date < '2023-01-07' then 'Christmas Holidays'

end as "Period"

from new_users

where creation_date >= '2022-12-12'

and creation_date < '2023-01-07'

group by "Days"

order by "Days"