MLDZMNstdis1
    with pro as (select
    tx_signer,
    s.tx_hash as proposal
    from near.core.fact_transactions s
    left join near.core.fact_actions_events_function_call a on a.tx_hash = s.tx_hash
    left join near.core.dim_address_labels b ON b.address = s.tx_receiver

    where s.block_timestamp>=dateadd('year', -2, current_date)
    and s.tx_status = 'Success'
    and method_name = 'add_proposal'
    and label_type = 'dao'
    ),

    tb1 as (
    select
    'Osmosis' as network,
    VOTER,
    count(distinct PROPOSAL_id) as no_proposals
    from osmosis.core.fact_governance_votes
    where TX_SUCCEEDED = 'TRUE'
    group by 1,2
    union all
    select
    'Solana' as network,
    VOTER,
    count(distinct PROPOSAL) as no_proposals
    from solana.core.fact_proposal_votes
    where BLOCK_TIMESTAMP >= dateadd('year', -2, current_date)
    and SUCCEEDED = 'TRUE'
    group by 1,2
    union all
    select
    'NEAR' as network,
    s.tx_signer as VOTER,
    count(distinct proposal) as no_proposals
    from near.core.fact_transactions s
    Run a query to Download Data