sum(amount/pow(10,decimal)) as axelar_amount_in

from axelar.core.fact_transfers

where transfer_type in ('AXELAR','IBC_TRANSFER_IN')

and currency = 'uaxl'

group by 1)

,

sender as (select sender,

sum(amount/pow(10,decimal)) as axelar_amount_out

from axelar.core.fact_transfers

where transfer_type in ('AXELAR','IBC_TRANSFER_OUT')

and currency = 'uaxl'

group by 1)

,

tb1 as ( select receiver as user,

axelar_amount_in-axelar_amount_out as balance

from receiver a join sender b on a.receiver = b.sender

order by 2 desc )

select count(DISTINCT user) as total_holder,

sum(balance) as total_amount

from tb1

where balance > 0