select

distinct pool_id[0] as pool,

count(distinct tx_id) as actions,

count(distinct LIQUIDITY_PROVIDER_ADDRESS) as users

from osmosis.core.fact_liquidity_provider_actions

where ACTION in ('pool_joined')

and LIQUIDITY_PROVIDER_ADDRESS in (

select

DISTINCT LIQUIDITY_PROVIDER_ADDRESS AS exitors

from osmosis.core.fact_liquidity_provider_actions where ACTION in ('pool_exited')

and POOL_ID[0]='1011'

) and pool_id[0]<>1011

group by 1

order by 3 desc

select case when users>6 then pool else 'Others' end as pool,

actions,users from tab1