proposal_id,

description,

count(distinct(tx_id)) as n_amount_votes

from cosmos.core.fact_governance_votes

join cosmos.core.dim_vote_options using (vote_option)

group by proposal_id, description),

cosmos_avg as (select

description as vote,

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

'cosmos' as chain

from cosmos_votes

group by vote)

select * from cosmos_avg