'Approved' as type,

count (distinct iff(vote_option in (1, 3), tx_id, null)) as approved,

count (distinct iff(vote_option not in (1, 3), tx_id, null)) as rejected,

(approved / (approved + rejected)) * 100 as approved_percent

from cosmos.core.fact_governance_votes

where tx_succeeded = 1