block_timestamp,

tx_hash,

event_inputs:"proposalId"::integer as proposal_id,

event_inputs:voter::string as voter,

case event_inputs:"support"

when '1' then 'for'

when '0' then 'against'

when '2' then 'abstain'

end as vote,

case event_inputs:"support"

when '1' then 1

when '0' then -1

when '2' then 0

end as vote_math,

event_inputs:votes::integer as n_votes,

vote_math * n_votes as total_vote

from ethereum.core.fact_event_logs

where contract_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'

and event_name = 'VoteCast')

select voter,

sum(n_votes) as total_votes

from votes

group by voter

order by total_votes desc

limit 10