from ethereum.core.ez_token_transfers

where origin_to_address = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'

and from_address = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'

and contract_address = '0x4d224452801aced8b2f0aebe155379bb5d594381'

,

deposit as ( select 'Deposit' as type, origin_from_address, amount

from ethereum.core.ez_token_transfers

where ORIGIN_TO_ADDRESS = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9'

and to_address = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9'

and contract_address = '0x4d224452801aced8b2f0aebe155379bb5d594381'

and origin_from_address in (select to_address from airdrop))

select sum(a.amount) as airdrop_amount, sum(b.amount) as deposit_amount , (airdrop_amount/147000000)*10

from airdrop a join deposit b on a.to_address = b.origin_from_address