with t0 as (

select decoded_instruction:args:side::string as side

, decoded_instruction:args:weight::int * power(10, -6) as weight

, signers[0]::string as voter

, value:pubkey::string AS proposal

, value:name::string AS name

, block_timestamp

from solana.core.fact_decoded_instructions i

, LATERAL FLATTEN(input => decoded_instruction:accounts)

where block_timestamp >= '2024-11-16'

and i.program_id in (

'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'

)

and name = 'proposal'

and proposal = 'ByQ21v3hqdQVwPHsfwurrtEAH8pB3DYuLdp9jU2Hwnd4'

and side is not null

and side > 0

and weight is not null

and event_type = 'setVote'

qualify(

row_number() over (partition by voter order by block_timestamp desc) = 1

)

select proposal

, side

, case when side = '1' then 'Burning Cat'

when side = '2' then 'PPP'

when side = '3' then 'In Space'

when side = '4' then 'Discovery'

when side = '5' then 'Jupiverse??'

when side = '6' then 'The Current Default'

end as options

, round(sum(weight)) as votes

, count(1) as n_voters

, max(block_timestamp)