'Cosmos' as blockchain,

count(distinct proposal_id) as no_of_proposals,

count(distinct proposer) as no_of_proposers,

count(distinct case when proposal_id in (SELECT distinct proposal_id from cosmos.core.fact_governance_votes)

then proposal_id end) as no_of_successful_proposals,

count(distinct case when proposal_id not in (SELECT distinct proposal_id from cosmos.core.fact_governance_votes)

then proposal_id end) as no_of_unsuccessful_proposals,

round((no_of_successful_proposals / no_of_proposals * 100),0) as pct_of_successful_proposals,

round((no_of_unsuccessful_proposals / no_of_proposals * 100),0) as pct_of_unsuccessful_proposals,

(select count(distinct voter) from cosmos.core.fact_governance_votes) as no_of_voters

from cosmos.core.fact_governance_submit_proposal

where tx_succeeded

group by 1