with pool as (
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