AzinVote 5
Updated 2023-03-01
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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