event_inputs:proposalId AS "Proposal",

MAX(block_timestamp) as "Maximum time",

SUM(event_inputs:votes) AS "Votes"

-- COUNT(DISTINCT event_inputs:voter) AS addresses

FROM ethereum.core.fact_event_logs

WHERE tx_status = 'SUCCESS'

AND origin_to_address = '0x6f3e6272a167e8accb32072d08e0957f9c79223d' -- NounsDAOProxy address

AND event_name = 'VoteCast'

GROUP BY 1

ORDER BY 3 DESC

LIMIT 10;