select

proposal_id

from terra.core.fact_governance_votes

group by proposal_id

order by proposal_id desc

limit 5

),

governance_votes_transactions_1 as (

select

tx_id,

block_timestamp,

voter,

proposal_id,

vote_option_text

from terra.core.fact_governance_votes

where tx_succeeded = true

and proposal_id in (select proposal_id from last_5_proposal)

),

governance_votes_transactions_2 as (

select

tx_id,

block_timestamp,

voter,

proposal_id,

vote_option_text

from terra.core.fact_governance_votes

where tx_succeeded = true

and proposal_id not in (select proposal_id from last_5_proposal)

),

delegate_luna as (

select

delegator_address as address,

sum(amount) as amount

from terra.core.ez_staking

where action = 'Delegate'