voter

, count(1) as proposals_participated

, sum(voting_power)/18 as avg_voting_power

from ETHEREUM.CORE.EZ_SNAPSHOT

where space_id = 'apecoin.eth'

and year(proposal_start_time) = year(current_date)

group by 1

order by 2 desc

limit 50