select

label,

raw_metadata[0]['account_address']::string as validator

from osmosis.core.dim_labels

where label_subtype = 'validator'

),

validators_vote as (

select

voter

from osmosis.core.fact_governance_votes

where proposal_id = '362'

and TX_STATUS = 'SUCCEEDED'

and voter in (select validator from validators)

),

validators_vote_count as (

select count(distinct voter) as voters from validators_vote

),

non_validators_vote as (

select

voter

from osmosis.core.fact_governance_votes

where proposal_id = '362'

and TX_STATUS = 'SUCCEEDED'

and voter not in (select validator from validators)

),

non_validators_vote_count as (

select count(distinct voter) as voters from non_validators_vote

),

previous_nv as (