select
ORIGIN_FROM_ADDRESS voter,
count (distinct EVENT_INPUTS:proposalId) unique_proposal_ids_voted,
sum(EVENT_INPUTS:votes) minted_tokens
from ethereum.core.fact_event_logs
where
ORIGIN_TO_ADDRESS ='0x6f3e6272a167e8accb32072d08e0957f9c79223d'
and EVENT_NAME = 'VoteCast'
and CONTRACT_ADDRESS = '0x6f3e6272a167e8accb32072d08e0957f9c79223d'
group by 1 order by 3 desc limit 10