WITH temp AS (
SELECT
PROPOSAL_ID AS IDs,
VOTER as USER_V,
MAX(VOTE_TIMESTAMP) as time
FROM ethereum.core.ez_snapshot
WHERE SPACE_ID = 'impossiblefinance.eth'
GROUP BY VOTER, PROPOSAL_ID
)
SELECT
VOTER,
SUM(VOTING_POWER) AS "IF Voted",
COUNT(DISTINCT PROPOSAL_ID) AS "# of proposals"
FROM temp
LEFT JOIN ethereum.core.ez_snapshot ON USER_V = VOTER AND time = VOTE_TIMESTAMP AND PROPOSAL_ID = IDs
WHERE SPACE_ID = 'impossiblefinance.eth'
GROUP BY 1
ORDER BY 2 DESC
LIMIT 100