with pool as (

SELECT POOL_ADDRESS , POOL_NAME

FROM ethereum.dex_liquidity_pools

where platform ='sushiswap'

)

,

mas as (

SELECT POOL_NAME , sum(balance) as MasterChef

from ethereum.erc20_balances

left outer join pool P on POOL_ADDRESS = contract_address

where balance_date = '2022-04-01'

and user_address = '0xc2edad668740f1aa35e4d8f227fb8e17dca888cd'

and POOL_NAME is not NULL

group by 1

)

,

oth as (

SELECT POOL_NAME , sum(balance) as other

from ethereum.erc20_balances

left outer join pool P on POOL_ADDRESS = contract_address

where balance_date = '2022-04-01'

and user_address <> '0xc2edad668740f1aa35e4d8f227fb8e17dca888cd'

and POOL_NAME is not NULL

group by 1

)

SELECT O.POOL_NAME , other , MasterChef

from oth O

left outer join mas M on M.POOL_NAME = O.POOL_NAME

where MasterChef is not NULL

order by 3 desc