proposal_id,

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

FROM cosmos.core.fact_governance_proposal_deposits

WHERE proposal_id IN (

SELECT

proposal_id

FROM cosmos.core.fact_governance_submit_proposal

WHERE tx_succeeded = TRUE

AND proposer IN ('cosmos1vgyvt6xml92vl9l04qj3vqffqyz4j4esyzdxny', 'cosmos1l4qqnt2ezpamfkh6ra3rvcsd8q25g4jkxlchvj')

GROUP BY proposal_id

ORDER BY proposal_id ASC