proposal_id,

count(distinct(tx_id)) as n_amount_votes

from terra.core.fact_governance_votes

group by proposal_id),

terra_avg as (select

round(avg(n_amount_votes),1) as avg_votes,

median(n_amount_votes) as median_votes,

'terra' as chain

from terra_votes),

cosmos_votes as (select

proposal_id,

count(distinct(tx_id)) as n_amount_votes

from cosmos.core.fact_governance_votes

group by proposal_id

),

cosmos_avg as (select

round(avg(n_amount_votes),1) as avg_votes,

median(n_amount_votes) as median_votes,

'cosmos' as chain

from cosmos_votes

),

osmosis_votes as (select

proposal_id,

count(distinct(tx_id)) as n_votes

from osmosis.core.fact_governance_votes v

where v.vote_option != 'VOTE_OPTION_UNSPECIFIED'

group by proposal_id),

osmosis_avg as (select

round(avg(n_votes),1) as avg_votes,

median(n_votes) as median_votes,