origin_from_address as wallet,

count(distinct tx_hash) as number_of_vote

from ethereum.core.fact_event_logs

where contract_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'

and origin_function_signature in ('0x56781388', '0x7b3c71d3')

and tx_status = 'SUCCESS'

and event_removed = false

group by wallet

order by number_of_vote desc