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),

n_providers as (select

balance_date as date,

t.pool_address as pool_address,

t.pool_name as pool_name,

count(*) as n_providers

from ethereum.erc20_balances bal, top_20_pools t

where balance_date >= '2022-1-1'

and contract_address = t.pool_address

group by date, pool_address, pool_name)

select * from n_providers