count(distinct tx_id) as votes,

(select count(distinct tx_id) from cosmos.core.fact_governance_submit_proposal) as proposals,

count(distinct voter) as voters,

votes / count(distinct date_trunc('month', block_timestamp)::date) as monthly_average_votes,

voters / count(distinct date_trunc('month', block_timestamp)::date) as monthly_average_voters,

proposals / count(distinct date_trunc('month', block_timestamp)::date) as monthly_average_proposals

from cosmos.core.fact_governance_votes

where tx_succeeded = 1