with

proposals as (

select distinct proposal_id,

min(block_timestamp) as created_at

from osmosis.core.fact_governance_submit_proposal

WHERE block_timestamp >= '{{start_date}}'

AND block_timestamp <= '{{end_date}}'

group by 1

),

validators as (

select distinct validator,

min(created_at) as first_participation

from osmosis.core.fact_governance_validator_votes v

WHERE

(v.VALIDATOR ='{{validator_1}}'

or v.VALIDATOR ='{{validator_2}}'

or v.VALIDATOR ='{{validator_3}}')

AND v.CREATED_AT >= '{{start_date}}'

AND v.CREATED_AT <= '{{end_date}}'

group by 1

),

final as (

trunc(created_at,'day') as date,

validator,

count(distinct proposal_id) as possible_proposals

from proposals x

join validators y on x.created_at>first_participation

group by 1,2

SELECT

date,

y.VALIDATOR,

y.possible_proposals,

case when count(distinct proposal_id)>possible_proposals then possible_proposals else count(distinct proposal_id) end as proposals_participated,