when voter_label_subtype is null then 'user'

else voter_label_subtype end as type,case

when option = 'VOTE_OPTION_NO' then 'No'

when option = 'VOTE_OPTION_NO_WITH_VETO' then 'NoWithVeto'

when option = 'VOTE_OPTION_ABSTAIN' then 'Abstain'

when option = 'VOTE_OPTION_YES' then 'Yes'

else option end as vote_option

from terra.gov_vote

where proposal_id in ('1092', '1075', '1046', '1025', '1014')),

title as (select proposal_id, title, date(block_timestamp) as dt

from terra.gov_submit_proposal

order by 1 asc),

vp as (select address, avg(voting_power) as vp

from terra.validator_voting_power

where date(block_timestamp) = CURRENT_DATE - 2

group by 1),

label as (select label, vp_address, delegator_address as voter_add

from terra.validator_labels),

vplabel as (select a.address, b.voter_add, b.label, a.vp

from vp a

left outer join label b on a.address = b.vp_address),

vp_user as (select address, balance

from terra.daily_balances

where currency = 'LUNA' and balance_type = 'staked' and date = CURRENT_DATE - 2 and balance > 0),

yess as (select proposal_id, voter, type

from raw

where vote_option = 'Yes')

select a.proposal_id, a.voter, a.type, b.balance, case