SELECT

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

min(date_trunc('month', block_timestamp)) as min_week

FROM osmosis.core.fact_staking

LEFT outer JOIN osmosis.core.dim_labels

ON address = validator_address

where currency LIKE 'uosmo'

GROUP BY 1

SELECT

datediff('month', min_week, block_timestamp) as week_diff,

count(*) as validator_Votes,

count(DISTINCT validator_address) as validators

FROM osmosis.core.fact_governance_votes

LEFT outer JOIN tab1

ON voter = validator_address

WHERE voter in (SELECT validator_address from tab1)

GROUP BY 1

having week_diff >= 0