PROPOSAL_START_TIME as "Proposal Start Time",

proposal_title as "Proposal title",

proposal_id as "Proposal ID",

PROPOSAL_TEXT as "Proposal text",

PROPOSAL_AUTHOR as "Proposal Author",

count (DISTINCT voter) as "Total voters",

sum (voting_power) as "Total voting power ($OP)",

CHOICES as "Proposal Choices",

PROPOSAL_END_TIME as "Proposal End Time",

FROM ethereum.core.ez_snapshot

where space_id = 'opcollective.eth'

GROUP by 1,2,3,4,5,8,9

order by 1 asc