COUNT(DISTINCT POOL_ADDRESS) AS total_pools,

COUNT(DISTINCT LP_TOKEN_ADDRESS) AS total_lp_token_addresses,

COUNT(DISTINCT TX_ID) AS total_actions,

COUNT(DISTINCT pool_name) AS total_pools2,

COUNT(

DISTINCT CASE

WHEN LP_ACTION = 'add_liquidity' THEN TX_ID

END

) AS added_liquidity_actions,

COUNT(

DISTINCT CASE

WHEN LP_ACTION = 'remove_liquidity' THEN TX_ID

END

) AS removed_liquidity_actions

sei.defi.fact_lp_actions;