WITH vote_counts AS (

SELECT proposal_id,

SUM(CASE WHEN LOWER(support) <> 'true' THEN voting_power ::NUMBER ELSE 0 END) AS votes_against,

SUM(CASE WHEN LOWER(support) = 'true' THEN voting_power :: NUMBER ELSE 0 END) AS votes_for

FROM ethereum.aave.ez_votes

GROUP BY 1

SELECT p.* ,v.votes_for,v.votes_against

FROM ethereum.aave.ez_proposals p

LEFT JOIN vote_counts v

ON p.proposal_id = v.proposal_id

ORDER BY p.proposal_id::NUMERIC DESC