count(distinct t.tx_hash) as total_votes,

count(distinct t.tx_signer) as voters

from near.core.fact_transactions t

inner join near.core.fact_actions_events_function_call c

on c.tx_hash=t.tx_hash

where c.method_name ='vote'

group by dao

order by voters desc

limit 10