select date_trunc ('week',block_timestamp) as date,

voter as Users,

count (distinct tx_id) as transactions_count

from osmosis.core.fact_governance_votes

where tx_status = 'SUCCEEDED'

group by 1,2

having transactions_count >= 10),

tab2 as (select

date_trunc ('week',block_timestamp) as date,

count (distinct voter) as active_voters

from osmosis.core.fact_governance_votes

where voter in (select users from tab)

and tx_status = 'SUCCEEDED'

group by date

order by date asc)

select avg(active_voters) as avg_voters from tab2