select receiver,

sum (amount/pow(10,6)) as Receive_Volume

from terra.core.ez_transfers

where currency = 'uluna'

and tx_succeeded ='TRUE'

group by 1),

sendtable as (

select sender,

sum (amount/pow(10,6)) as Send_Volume

from terra.core.ez_transfers

where currency = 'uluna'

and tx_succeeded ='TRUE'

group by 1)

select receiver as Holder,

sum (receive_volume - send_volume) as Balance

from receivetable t1 join sendtable t2 on t1.receiver = t2.sender

group by 1 having Balance > 0

order by 2 desc

limit 100