SELECT sum(AMOUNT_USD) as inpu , sum(AMOUNT) as inpu_num , SYMBOL

from ethereum.udm_events

where to_ADDRESS_NAME like '%sushiswap: bentoboxv1%'

and to_address = '0xf5bce5077908a1b7370b9ae04adc565ebd643966'

and from_address <> '0xf5bce5077908a1b7370b9ae04adc565ebd643966'

and event_type like '%erc20_transfer%'

group by 3

) ,

outflow as (

SELECT sum(AMOUNT_USD) as outpu , sum(AMOUNT) as outpu_num, SYMBOL

from ethereum.udm_events

where from_ADDRESS_NAME like '%sushiswap: bentoboxv1%'

and from_address = '0xf5bce5077908a1b7370b9ae04adc565ebd643966'

and to_address <> '0xf5bce5077908a1b7370b9ae04adc565ebd643966'

and event_type like '%erc20_transfer%'

group by 3

)

SELECT I.symbol ,outpu_num as withdraw_amount , inpu_num -outpu_num as net2 , inpu_num as deposit_amount

from Inflow I ,outflow O

where I.symbol = O.symbol