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
›
⌄
select
tl.users,
sum(t1.Aamount in t2.Amount_out) as User_Hold
from
(
select
tx_receiver as users,
sum (deposit / pow(10, 24)) as Aamount_in
from
near.core.fact_transfers
group by
users
) as tl
inner join (
select
tx_signer as users,
sum (deposit / pow(10, 24)) as Amount_out from
near.core.fact_transfers
group by
users
) as t2 on tl.users = t2.users
group by
t1.users
having
User_Hold > →
order by
Limit
User_Hold desc
20
Run a query to Download Data