drone-mostafa% USD
Updated 2023-05-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
›
⌄
with alls as (SELECT
ORIGIN_FROM_ADDRESS,
sum (AMOUNT_IN_USD) as USD_Users
FROM avalanche.core.ez_dex_swaps
WHERE ORIGIN_FROM_ADDRESS != '{{User_wallet}}'
GROUP BY 1),
targets as (SELECT
sum (AMOUNT_IN_USD) as USD_Target
FROM avalanche.core.ez_dex_swaps
WHERE ORIGIN_FROM_ADDRESS = '{{User_wallet}}'
),
dex_users as (SELECT
count (DISTINCT ORIGIN_FROM_ADDRESS) as All_users
FROM avalanche.core.ez_dex_swaps)
SELECT
All_users as al,
count (DISTINCT (CASE when USD_Users > USD_Target then ORIGIN_FROM_ADDRESS end)) as greater,
count (DISTINCT (CASE when USD_Users < USD_Target then ORIGIN_FROM_ADDRESS end)) as less,
(greater * 100) / al as "% greater",
(less * 100) / al as "% less"
FROM alls
LEFT JOIN targets
LEFT JOIN dex_users
GROUP BY 1
Run a query to Download Data