-- BLOCK_TIMESTAMP::date as day,

count(tx_id) as num_tx,

count(DISTINCT voter) as num_voter,

VOTE_OPTION_TEXT,

count(DISTINCT PROPOSAL_ID) as num_pro

from terra.core.fact_governance_votes

where TX_SUCCEEDED = TRUE

-- and PROPOSAL_ID =3796

GROUP by VOTE_OPTION_TEXT