SELECT

proposal_id as p_id,

PROPOSAL_TYPE as p_type,

block_timestamp as p_time

FROM cosmos.core.fact_governance_submit_proposal

SELECT

avg(voters) as voters,

COUNT(DISTINCT p_id) as proposals

FROM (

SELECT

p_time,

p_type,

p_id,

COUNT(DISTINCT VOTER) as voters,

sum(VOTE_WEIGHT) as voting_power

FROM cosmos.core.fact_governance_votes

LEFT outer JOIN tab1

ON p_id = proposal_id

WHERE p_time is not NULL

GROUP BY 1,2,3