SELECT

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

min(block_timestamp) as first_day

FROM osmosis.core.fact_staking

LEFT outer JOIN osmosis.core.dim_labels

ON address = validator_address

where currency LIKE 'uosmo'

GROUP BY 1

), tab2 as (

SELECT

voter,

count(*) as votes

FROM osmosis.core.fact_governance_votes

WHERE voter in (SELECT validator_address from tab1)

GROUP BY 1

SELECT *

from tab1

LEFT outer JOIN tab2 ON validator_address = voter

where not votes is NULL