SELECT

pool_address as pa1,

pool_name as pn1

from optimism.velodrome.ez_pool_details

), pool_2 as (

SELECT

pool_address as pa2,

pool_name as pn2

from optimism.velodrome.ez_pool_details

SELECT

sum(CASE WHEN LP_ACTION LIKE 'withdraw' THEN -1 * LP_TOKEN_AMOUNT_USD ELSE LP_TOKEN_AMOUNT_USD END) as net_liquidity,

sum(CASE WHEN LP_ACTION LIKE 'withdraw' THEN 1 END) as withdraw,

sum(CASE WHEN LP_ACTION LIKE 'deposit' THEN 1 END) as deposit,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as users

FROM optimism.velodrome.ez_lp_actions

LEFT OUTER JOIN pool_1

on pa1 = pool_address

LEFT OUTER JOIN pool_2

on pa2 = pool_address

WHERE pool_address in (SELECT pa1 from pool_1)

OR pool_address in (SELECT pa2 from pool_2)