jkhuhnke11Percentage Submitters That Deposit At Least 10 ATOM
    Updated 2023-04-13
    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,
    Run a query to Download Data