MufasaComparison of Depositors and average number of depositors on Proposal #362 vs Recent Proposals Osmosis
    Updated 2022-11-22
    with first_data as (
    select count (distinct depositor) as total_count_of_depositors,
    sum (amount) as total_amount_deposited
    from osmosis.core.fact_governance_proposal_deposits
    where tx_status = 'SUCCEEDED'
    and proposal_id in ('362'))

    select 'Other Proposals' as category,
    avg (total_count_of_depositors) as average_depositors_count,
    avg (total_amount_deposited) as average_amount_deposited
    from (select proposal_id,
    case when proposal_id = '362' then 'Proposal #362' else 'Other Recent Proposals' end as proposals,
    count (distinct depositor) as total_count_of_depositors,
    sum (amount) as total_amount_deposited
    from osmosis.core.fact_governance_proposal_deposits
    where proposal_id::numeric >= '300' and proposal_id::numeric <= '365'
    and tx_status = 'SUCCEEDED'
    group by proposal_id,2)

    union ALL

    select 'Proposal #362' as category,
    total_count_of_depositors,
    total_amount_deposited
    from first_data
    Run a query to Download Data