, PROPOSAL_START_TIME

, PROPOSAL_AUTHOR

, PROPOSAL_ID

, concat(proposalRank , concat(': ', proposal_title)) as PROPOSAL_TITLE

, OPTION_ID

, "OPTION"

, voters

, voting_power

FROM (

SELECT DISTINCT DENSE_RANK() OVER ( ORDER BY PROPOSAL_START_TIME ) as prank

, PROPOSAL_START_TIME

, PROPOSAL_AUTHOR

, proposal_id

, proposal_title

, CHOICES

, o.VALUE as OPTION_ID

, CHOICES[o.VALUE::NUMERIC-1] as "OPTION"

, COUNT(DISTINCT VOTER) OVER (partition by proposal_id, VOTE_OPTION) as voters

, sum(VOTING_POWER) OVER (partition by proposal_id, VOTE_OPTION) as voting_power

FROM ethereum.core.ez_snapshot as s

left join TABLE(flatten(INPUT => s.VOTE_OPTION)) o

WHERE space_id = 'snapshot.dcl.eth'

AND VOTING_POWER > 0

AND o.VALUE <> ''

) as v

ORDER BY PROPOSAL_START_TIME