count(distinct(voter)) as unique_voters,

count(distinct(tx_id)) as total_votes,

'cosmos' as chain

from cosmos.core.fact_governance_votes v

where block_timestamp >= '2022-6-3'),

osmosis_unique_voters as (select

count(distinct(voter)) as unique_voters,

count(distinct(tx_id)) as total_votes,

'osmosis' as chain

from osmosis.core.fact_governance_votes

where block_timestamp >= '2022-6-3'),

terra_unique_voters as (select

count(distinct(voter)) as unique_voters,

count(distinct(tx_id)) as total_votes,

'terra' as chain

from terra.core.fact_governance_votes

where block_timestamp >= '2022-6-3')

select * from cosmos_unique_voters

select * from osmosis_unique_voters

union

select * from terra_unique_voters