SELECT

proposal_id,

proposer

FROM cosmos.core.fact_governance_submit_proposal

WHERE proposal_id IN (

SELECT

DISTINCT proposal_id

FROM cosmos.core.fact_governance_votes

)

SELECT

v.proposal_id,

sum(amount / POW(10,6)) as amt_deposited

FROM voted_on v

INNER JOIN cosmos.core.fact_governance_proposal_deposits d

ON v.proposer = d.depositor

AND v.proposal_id = d.proposal_id

WHERE v.proposal_id < 104

GROUP BY (v.proposal_id)

ORDER BY v.proposal_id DESC