(

select *

from

terra.gov_vote

where

voter_address_label='flipside'

)

, bites as

(

select

proposal_id as pid

, voter_address_label as label

, option as vote

from

terra.gov_vote

where

voter_address_label='Terra Bites'

)

, joint_votes as

(

select

coalesce(a.proposal_id, b.pid)::integer as Proposal_ID

, a.voter_address_label

, a.option as Flipside_vote

, b.label

, b.vote as Terra_Bites_Vote

from

flipside a

full join

bites b

on

a.proposal_id=b.pid

order by

Proposal_ID desc

)