with t as (
select
date_trunc('week', a.block_timestamp)::date as week,
count(distinct voter) as voters_count,
sum(coalesce(vote_weight, 0)) as total_voting_weight
from Terra.core.fact_governance_votes a
join Terra.core.fact_governance_submit_proposal b
using(proposal_id)
group by 1
)
select
avg(voters_count) as average_voters_count,
avg(total_voting_weight) as average_voting_weight
from t