select 'Cosmos' as chain,

proposal_id::string,

count (distinct tx_id) as Votes_Count,

count (distinct voter) as Voters_Count

from cosmos.core.fact_governance_votes

where tx_succeeded = 'TRUE'

group by 1,2

union ALL

select 'Osmosis' as chain,

proposal_id::string,

count (distinct tx_id) as Votes_Count,

count (distinct voter) as Voters_Count

from osmosis.core.fact_governance_votes

where tx_succeeded = 'TRUE'

group by 1,2

union ALL

select 'Terra' as chain,

proposal_id::string,

count (distinct tx_id) as Votes_Count,

count (distinct voter) as Voters_Count

from terra.core.fact_governance_votes

where tx_succeeded = 'TRUE'

group by 1,2)

select * from maintable

where chain = 'Cosmos'

order by Voters_Count desc

limit 10