Moegov
Updated 2024-10-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with base as (
select
CREATED_AT as date,
id,
(call:transaction:"from") as receiver,
call:returnValues:destinationChain as destination_chain
from
axelar.axelscan.fact_gmp
where
call ilike '%0xB5FB4BE02232B1bBA4dC8f81dc24C26980dE9e3C%'
and DESTINATION_CHAIN ilike 'ethereum'
),
tb1 as (
select
distinct VOTER,
case
when voter in (
select
receiver
from
base
) then 'axl_user'
else 'other'
end as type,
count(distinct PROPOSAL_ID) as no_proposals,
count(*) as no_votes
from
external.snapshot.ez_snapshot
group by
1,
2
)
select
type,
case
when no_proposals < 3 then 'A. less than 3 proposals'
QueryRunArchived: QueryRun has been archived