distinct tx:body:messages[0]:contract as contracts,

block_timestamp as date,

min(block_timestamp) as deploy_day

from terra.core.fact_transactions

where TX_SUCCEEDED='TRUE'

and block_timestamp >= '2022-12-20'

group by 1,2

SELECT case when date < '2023-01-01' then 'Before Start of 2023' else 'After Start of 2023' end as timeframe,

count(distinct contracts) as total_contracts

from contracts

group by 1