select voter,

count (distinct tx_id) as total_count_of_votes

-- count (distinct voter) as total_count_of_voters

from osmosis.core.fact_governance_votes

where tx_status = 'SUCCEEDED'

and proposal_id in ('362')

group by voter

order by total_count_of_votes DESC

limit 10

select * from top_voters;