select

PROPOSAL_ID,

count(distinct voter) as voters,

count(distinct tx_id) as votes,

avg(vote_weight) as avg_weight

from

osmosis.core.fact_governance_votes

where tx_status='SUCCEEDED' and proposal_id != '362'

group by 1

select

'Other Proposals Average' as lbl,

avg(voters) as avg_voters,

avg(votes) as avg_votes,

avg(avg_weight) as avgweight

from

daily_stats

union all

select

'Proposal #362' as lbl,

count(distinct voter) as voters,

count(distinct tx_id) as votes,

avg(vote_weight) as avg_weight

from

osmosis.core.fact_governance_votes

where tx_status='SUCCEEDED' and proposal_id = '362'

group by 1