(select

sum(case when to_CURRENCY='ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4' then to_AMOUNT/1e6 else null end) as inbflow,

sum(case when FROM_CURRENCY='ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4' then FROM_AMOUNT/1e6 else null end) as outflow,

TRADER

from

terra.core.ez_swaps

group by TRADER),

t2 as

(select

case when inbflow is null then 0 else inbflow end as infloww,

case when outflow is null then 0 else outflow end as outfloww, *

from t1

select sum(infloww-outfloww) as volume , TRADER from t2

group by 2

order by 1 asc

limit 10