SELECT pool_name , pool_address

from ethereum.dex_liquidity_pools

where platform = 'sushiswap'

)

SELECT pool_name , sum(amount_usd) as TVL

from ethereum.erc20_balances B, pool P

where user_address = pool_address

and balance_date = '2022-04-06'

and amount_usd is not null

group by 1

order by 2 DESC