with votes as (
select
voter,
count(tx_id) as no_votes
from terra.core.fact_governance_votes
where proposal_id = '3665'
and tx_succeeded = 'TRUE'
group by voter
)
select
count(distinct voter) as switchers,
(switchers/304)*100 as percent_switchers
from votes
where no_votes > 1