raw_metadata[0]:"account_address" as validators

from osmosis.core.dim_labels

where label_subtype ilike 'validator')

select

voter,

count (distinct tx_id) as no_votes

from osmosis.core.fact_governance_votes

where BLOCK_TIMESTAMP ilike '2022%'

and voter not in (select validators from tb1)

group by 1

order by 2 DESC

limit 10