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

voter as Users,

count (distinct tx_id) as votes_count

from osmosis.core.fact_governance_votes

where tx_status = 'SUCCEEDED'

group by 1,2

having votes_count >= 10)

select

distinct voter as active_voters,

count (distinct tx_id) as votes

from osmosis.core.fact_governance_votes

where voter in (select users from tab)

and tx_status = 'SUCCEEDED'

group by 1

order by 2 desc

limit 20