with tab1 as (

select min(BLOCK_TIMESTAMP::date)as date,raw_metadata[0]['account_address'] as validator_address

from osmosis.core.fact_staking

left join osmosis.core.dim_labels

on address=validator_address

where currency='uosmo'

group by 2)

select

validator_address

--,case

--when date>='2022-01-09' and date<'2022-05-16' then 'after prop 114'

--when date>='2022-05-16' and date<'2022-10-08' then 'after prop 196'

--when date>='2022-10-08' then 'after prop 337' end as prop_status

from tab1

where date>='2022-05-16'),

act2 as (

select BLOCK_TIMESTAMP::date as date,VOTER,PROPOSAL_ID,VOTE_WEIGHT,VOTE_OPTION

from osmosis.core.fact_governance_votes

where date>='2022-05-16'

group by 1,2,3,4,5)

select act2.date,VOTE_OPTION,PROPOSAL_ID,count(distinct VOTER)as voter_count,sum(VOTE_WEIGHT)as voting_power

from act1

left join act2

on act1.validator_address=act2.VOTER

where VOTE_OPTION is not null

group by 1,2,3