case

when date between '2023-01-07' and '2023-01-13' then 'Before launch'

else 'After launch' end as categ_date,

round(count(DISTINCT tx_id)/count(DISTINCT PROPOSAL_ID),2) as count_txs,

round(count(DISTINCT VOTER)/count(DISTINCT PROPOSAL_ID),2) as count_users

from terra.core.fact_governance_votes

where TX_SUCCEEDED and date BETWEEN '2023-01-07' and '2023-01-20'

group by 1,2