select case when vote_option[0] = '1' then 'Yes/For/Accept'

when vote_option[0] ='2' then 'No/Against/Decline'

when vote_option[0] ='3' then 'Abstain'

else 'Others/Null' end as vote_type,

count (distinct id) as Votes

from ethereum.core.ez_snapshot

group by 1),

realms as (

select case when vote_choice is not null then vote_choice

else null end as vote_type,

count (distinct tx_id) as Votes

from solana.core.fact_proposal_votes

where governance_platform = 'realms'

group by 1)

select 'Snapshot' as type, * from snapshot

union ALL

select 'Realms' as type, * from realms