select platform,

POOL_NAME,

sum(AMOUNT_IN_USD-AMOUNT_OUT_USD) as TVL

from ethereum.core.ez_dex_swaps

where AMOUNT_IN_USD-AMOUNT_OUT_USD>0

group by 1,2)

select platform,

COUNT (distinct pool_name)as count_of_qualified_pools

from dex

where TVL>100000

group by 1