select

to_address as user,

sum(raw_amount / power(10, 18)) as balance

from base.core.ez_token_transfers

where CONTRACT_ADDRESS ILIKE '0x940181a94A35A4569E4529A3CDfB74e38FD98631'

group by 1

UNION ALL

select

from_address as user,

sum(raw_amount / power(10, 18))*-1 as balance

from base.core.ez_token_transfers

where CONTRACT_ADDRESS ILIKE '0x940181a94A35A4569E4529A3CDfB74e38FD98631'

group by 1

)

select

user as Wallet,

sum(balance) as AERO_Balance

from tab1

group by 1

having AERO_Balance > 0

order by 2 desc