voter AS "Voter",

COUNT(DISTINCT tx_hash) AS "Votes",

("Votes" / (SELECT MAX(proposal_id) FROM ethereum.aave.ez_votes)) * 100 AS "Participation",

SUM(voting_power) / POW(10, 18) AS "Voting Power"

ethereum.aave.ez_votes votes

LEFT JOIN ethereum.core.dim_labels labels ON votes.voter = labels.address

GROUP BY

"Voter"

ORDER BY

"Voting Power" DESC