SELECT

proposal_id as p_id,

PROPOSAL_TYPE as p_type,

block_timestamp as p_time

FROM osmosis.core.fact_governance_submit_proposal

SELECT

avg(voters) as voters

FROM (

SELECT

date_trunc('week', block_timestamp) as p_time,

COUNT(DISTINCT VOTER) as voters,

sum(VOTE_WEIGHT) as voting_power

FROM osmosis.core.fact_governance_votes

LEFT outer JOIN tab1

ON p_id = proposal_id

WHERE p_time is not NULL

GROUP BY 1