select e1.pool_name, e1.pool_address, sum(e2.amount_usd) as liquidity_usd
FROM
(
select *
from ethereum.dex_liquidity_pools
where platform = 'sushiswap'
) as e1
INNER JOIN ethereum.erc20_balances as e2
ON e1.pool_address = e2.user_address
where e2.amount_usd != 0
and e2.balance_date >= CURRENT_DATE - 1
group by 1,2
order by 3 DESC
limit 3