select POOL_ADDRESS,

platform

from ethereum.core.dim_dex_liquidity_pools

where platform in ('sushiswap', 'uniswap-v2', 'uniswap-v3')

, tvl as (

select

POOL_ADDRESS as "Qualified DEX Liquidity Pools",

CASE

WHEN platform = 'uniswap-v3' or platform = 'uniswap-v2' THEN 'uniswap'

ELSE 'sushiswap'

END as "main platform",

count("Qualified DEX Liquidity Pools") as "Qualified pool Count",

sum(amount_usd) as "Balance in usd"

from ethereum.erc20_balances, all_pools

where user_address = POOL_ADDRESS

and balance_date = CURRENT_DATE - 1

and has_price = true

group by 1, 2

order by 1

)

select* from tvl where "Balance in usd" > 100000