with final as (with table1 as (with tab1 as (SELECT from_address as address, -1*amount AS amount

FROM ethereum.core.ez_token_transfers

WHERE contract_address = '0xb4bd4628e6efb0cb521d9ec35050c75840320374'

UNION ALL

SELECT to_address as address, amount AS amount

FROM ethereum.core.ez_token_transfers

WHERE contract_address = '0xb4bd4628e6efb0cb521d9ec35050c75840320374')

select address, sum(amount) as balance

from tab1

where address<>'0x0000000000000000000000000000000000000000'

group by 1)

select address, balance, case

when address='0x573c0609a8cac30b7a8a65e3652f0511caeffd30' THEN 'frETH Staking Address'

when address='0x0fbb8d17027b16810795b12cbeadc65b252530c4' THEN 'truefreeze.eth'

when address='0x6e77889ff348a16547caba3ce011cb120ed73bfc' THEN 'Vyper_contract'

when address='0xa4b35daf88a8c894c4664f0625c6e263c61bfcc9' THEN 'Uniswap V3: frETH 2'

when address='0xf921cca9334aed2f6f654cb9edefb47a5000dd44' THEN '🇧🇦🇧🇾.eth'

when address='0xa448c403d959dc755662a46714c72c118a77f750' THEN 'designatedshittingstreet.eth'

when address='0x9e1cc2e71d373ee2d140b7fa842fab101d6afa21' THEN 'sanice.eth'

when address='0x5a9638277f5146f0637fe2ad35b70d43f0e3167c' THEN 'Uniswap V3: frETH'

when address='0xee296f36e054854f7264890d52d61c4d9eb3b061' THEN 'tributestream.eth'

when address='0x231c1b262bbdf2816ba734bfbe7a351317485708' THEN 'dootuz.eth'

when address='0xa89542b64941800789f93710ef2d7f0165768c93' THEN '*🥑🐉🌌.eth'

when address='0x39e856863e5f6f0654a0b87b12bc921da23d06bb' THEN 'charliemarketplace.eth'

when address='0x0430605323465e26dc21fbaaa9a1a4be6ae9d496' THEN 'mrcryptids.eth'

when address='0x4c0c29539c463af348f8cba8c02d644a8d68c320' THEN 'xToken: Deployer'

when address='0xa45645ebb075a96d1c89511e28d3e9b94f3b7905' THEN 'FRZ Staking Contract'

when address='0x4c0c29539c463af348f8cba8c02d644a8d68c320' THEN 'xToken: Deployer'

else address

end as label

from table1

where balance>0

order by 2 desc)