sakineh5021-nIQRzBUntitled Query
    with inflow as (
    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
    ) ,

    Price_token as ( SELECT avg(price) as PRi, symbol , cast(hour as date )
    from ethereum.token_prices_hourly
    where cast(hour as date ) = '2022-03-21'
    group by 2 , 3
    )

    SELECT I.symbol as Locked_token , inpu_num -outpu_num as Number_of_Locked_tokens , Number_of_Locked_tokens*P.Pri as amount_usd
    from Inflow I ,outflow O , price_token P
    where I.SYMBOL = O.SYMBOL
    and I.SYMBOL = P.SYMBOL
    and Number_of_Locked_tokens >0
    order by 3 DESC