round(sum(amount_usd),2) as tvl,

CASE

WHEN pool_name = '0x64aa3364f17a4d01c6f1751fd97c2bd3d7e7f1d5-DAI LP' THEN 'OHM-DAI SLP'

ELSE pool_name

END as pool_name,

user_address as pool_address

from ethereum.erc20_balances bal

join ethereum.dex_liquidity_pools dex on

bal.user_address = dex.pool_address

where amount_usd > 0 and platform = 'sushiswap'

and balance_date = (select max(balance_date) from ethereum.erc20_balances)

group by 2,3

order by tvl desc

limit 10),

total_lp as (select

t.pool_address as pool_address,

sum(balance) as total_lp

from ethereum.erc20_balances bal, top_20_pools t

where balance_date = current_date()

and contract_address = t.pool_address

group by pool_address, pool_name),

top_holder_balance as (select

t.pool_address as pool_address,

max(balance) as balance_top_holder

from ethereum.erc20_balances bal, top_20_pools t

where balance_date = current_date()

and contract_address = t.pool_address

group by pool_address, pool_name),

totals_table as (select * from top_20_pools

left join total_lp using (pool_address)

left join top_holder_balance using (pool_address))