AzinVote 5
    Updated 2023-03-01
    with t1 as
    (select
    distinct (VOTER) as voter from
    axelar.core.fact_governance_votes)

    select
    count(distinct voter) as voters , case when TX_CALLER_ADDRESS is null then 'user' else 'validator' end as type from t1 a left join axelar.core.fact_validator_commission b
    on a.voter=b.TX_CALLER_ADDRESS
    group by type

    Run a query to Download Data