CASE

WHEN support = TRUE THEN 'For'

WHEN support = False THEN 'Against'

END AS "Support",

COUNT(DISTINCT tx_hash) AS "Votes",

COUNT(DISTINCT voter) AS "Voters",

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

ethereum.aave.ez_votes

GROUP BY

"Support"

ORDER BY

"Support" DESC