with validatorst as (

select address as validator_address,

label as validator_name,

raw_metadata[0]['account_address']::string as Account_Address,

raw_metadata[0]['rank']::string as Rank,

raw_metadata[0]['uptime']['address']::string as Proposer

from osmosis.core.dim_labels

where label_subtype = 'validator')

select voter,

validator_name,

count (distinct tx_id) as votes_count

from osmosis.core.fact_governance_votes t1 join validatorst t2 on t1.voter = t2.account_address

where tx_status = 'SUCCEEDED'

and proposal_id in ('362')

group by 1,2

order by 3 DESC

limit 20