LIQUIDITY_PROVIDER,

SUM(CASE WHEN ACTION = 'deposit' THEN 1 ELSE 0 END) AS TOTAL_DEPOSITS,

SUM(CASE WHEN ACTION = 'deposit' THEN AMOUNT ELSE 0 END) AS TOTAL_DEPOSIT_AMOUNT,

SUM(CASE WHEN ACTION = 'withdraw' THEN 1 ELSE 0 END) AS TOTAL_WITHDRAWALS,

SUM(CASE WHEN ACTION = 'withdraw' THEN AMOUNT ELSE 0 END) AS TOTAL_WITHDRAWAL_AMOUNT

FROM

solana.defi.fact_liquidity_pool_actions

WHERE

MINT = 'Df6yfrKC8kZE3KNkrHERKzAetSxbrWeniQfyJY4Jpump'

AND SUCCEEDED = TRUE

GROUP BY

LIQUIDITY_PROVIDER

HAVING

SUM(CASE WHEN ACTION = 'deposit' THEN 1 ELSE 0 END) > 1

AND SUM(CASE WHEN ACTION = 'withdraw' THEN 1 ELSE 0 END) > 1

ORDER BY

LIQUIDITY_PROVIDER;