event_inputs:proposalId as ProposalNumber,

sum(case when event_inputs:support::string = 1 then event_inputs:votes else 0 end) as Yes_votes,

sum(case when event_inputs:support::string = 0 then event_inputs:votes else 0 end)*-1 as No_votes,

case

when ProposalNumber = '1' then '4'

when ProposalNumber = '2' then '39'

when ProposalNumber = '3' then '66'

when ProposalNumber = '4' then '66'

when ProposalNumber = '5' then '69'

when ProposalNumber = '6' then '80'

when ProposalNumber = '7' then '95'

when ProposalNumber = '8' then '100'

when ProposalNumber = '9' then '118'

when ProposalNumber = '10' then '137'

when ProposalNumber = '11' then '150'

when ProposalNumber = '12' then '150'

when ProposalNumber = '13' then '154'

when ProposalNumber = '14' then '157'

when ProposalNumber = '15' then '158'

when ProposalNumber = '16' then '166'

when ProposalNumber = '17' then '190'

when ProposalNumber = '18' then '190'

when ProposalNumber = '19' then '211'

when ProposalNumber = '20' then '211'

end as quorum

from ethereum.core.fact_event_logs

where lower(contract_address) = lower('0x5d2C31ce16924C2a71D317e5BbFd5ce387854039') and event_name = 'VoteCast'

group by ProposalNumber