with votes as (
select
max(block_timestamp) as block_time,
voter,
vote_weight
from terra.core.fact_governance_votes
where proposal_id = '3794'
and tx_succeeded = 'TRUE'
group by voter, vote_weight
)
select
concat(vote_weight, ' vote') as vote_weight,
count(distinct voter) as votes
from votes
group by vote_weight