SELECT POOL_ADDRESS , POOL_NAME

FROM ethereum.dex_liquidity_pools

where platform ='sushiswap'

)

SELECT POOL_NAME , max(balance)

from ethereum.erc20_balances

left outer join pool P on POOL_ADDRESS = contract_address

where balance_date = '2022-04-01'

and POOL_NAME is not NULL

and balance is not NULL

group by 1