pool_id,

count(TX_ID) as exit_no,

sum(AMOUNT/1e6) as exit_vol

from osmosis.core.fact_liquidity_provider_actions

where TX_STATUS='SUCCEEDED'

and ACTION='pool_exited'

and CURRENCY='uosmo'

group by 1 order by 3 desc limit 10