news as (

SELECT

raw_metadata[0]['account_address'] as validator_address,

min(trunc(block_timestamp,'day')) as debut

FROM osmosis.core.fact_staking

JOIN osmosis.core.dim_labels ON address = validator_address

where currency LIKE 'uosmo'

GROUP BY 1

),

proposals_info as (

SELECT

proposal_id,

min(block_timestamp) as first_vote

FROM osmosis.core.fact_governance_votes

WHERE proposal_id in (196)

group by 1

)

SELECT

case when datediff('day',debut,first_vote) <30 then 'New validator'

else 'Old validator' end as type,

DESCRIPTION as vote,

count(DISTINCT voter) as voters,

sum(VOTE_WEIGHT) as voting_power

FROM osmosis.core.fact_governance_votes

JOIN osmosis.core.dim_vote_options ON VOTE_ID = vote_option

JOIN news on voter=validator_address

JOIN proposals_info on osmosis.core.fact_governance_votes.proposal_id=proposals_info.proposal_id

GROUP by 1,2 order by 1 asc