SELECT

DISTINCT CASE WHEN ACTION LIKE 'lp_tokens_burned' THEN LIQUIDITY_PROVIDER_ADDRESS END as withdraw

FROM osmosis.core.fact_liquidity_provider_actions

WHERE (ACTION LIKE 'lp_tokens_minted'

OR action LIKE 'lp_tokens_burned')

AND pool_id[0] = 872

SELECT

date_trunc('day', block_timestamp) as day,

pool_id[0],

count(*)

--DISTINCT CASE WHEN ACTION LIKE 'lp_tokens_burned' THEN LIQUIDITY_PROVIDER_ADDRESS END as withdraw

FROM osmosis.core.fact_liquidity_provider_actions

WHERE ACTION LIKE 'lp_tokens_minted'

AND LIQUIDITY_PROVIDER_ADDRESS in (SELECT * FROM tab1)

AND block_timestamp > '2023-01-15'

GROUP BY 1,2