proposal_type as type,

count(distinct tx_id) as proposals,

count(distinct proposer) as proposers

from cosmos.core.fact_governance_submit_proposal

where tx_succeeded = 1

group by 1