Abolfazl_771025terra_supply 20
Updated 2023-01-01Copy Reference Fork
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
›
⌄
with main as(select
DISTINCT MESSAGE_VALUE['sender'] as user,
count(TX_ID) as "bridge count",
sum(AMOUNT/1e6) as "bridge volume"
from terra.core.ez_transfers
where MESSAGE_TYPE='/ibc.applications.transfer.v1.MsgTransfer'
and CURRENCY='uluna'
group by 1)
select
case
when "bridge count" = 1 then 'bridge just one time'
when "bridge count" between 2 and 5 then 'bridge 2 - 5 time'
when "bridge count" between 6 and 10 then 'bridge 6 - 10 time'
when "bridge count" between 11 and 20 then 'bridge 11 - 20 time'
when "bridge count" between 21 and 50 then 'bridge 21 - 50 time'
when "bridge count" between 51 and 100 then 'bridge 51 - 100 time'
when "bridge count" between 101 and 200 then 'bridge 101 - 200 time'
when "bridge count" between 201 and 500 then 'bridge 201 - 500 time'
when "bridge count" between 501 and 1000 then 'bridge 501 - 1000 time'
else 'bridge more than 1000 time'
end as "bridge count",
count(user) as "count of bridger"
from main
group by 1
Run a query to Download Data