select date_trunc('day',block_timestamp) as date,

case when date >= '2023-01-14' then 'After Announcement' else 'Before Announcement' end as timeframe,

count (distinct tx_id) as Votes,

count (distinct voter) as Voters

from terra.core.fact_governance_votes

where date >= '2023-01-07' and date <= '2023-01-21'

and tx_succeeded = TRUE

group by 1,2