WITH voted_on AS (
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
)
),
pre_final AS (
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)
),
pre_final2 AS (
SELECT
proposal_id,
amt_deposited,
CASE when amt_deposited < 10 THEN
'less than 10 ATOM'
WHEN amt_deposited >= 10 THEN
'10 or more ATOM'
END AS label
FROM pre_final
ORDER BY proposal_id DESC
)
SELECT
count(proposal_id) as cnt,