ramishoowUntitled Query
Updated 2023-01-05
9
1
2
3
4
5
›
⌄
with ramishoow as (select sum(AMOUNT) as sent, SENDER from terra.core.ez_transfers WHERE CURRENCY='uluna' group by 2), rami as (select sum(AMOUNT) as rec, RECEIVER
from terra.core.ez_transfers WHERE CURRENCY='uluna' group by 2) select sum(rec)/1e4 as total_supply from rami a left join ramishoow b on a.RECEIVER=b.SENDER
--from terra.core.ez_transfers WHERE CURRENCY='uluna' group by 2) select sum(rec)/1e4 as total_supply from rami a left join ramishoow b on a.RECEIVER=b.SENDER
where sent is null limit 10
Run a query to Download Data