select count(distinct DELEGATOR_ADDRESS),
CASE
when DELEGATOR_ADDRESS=LIQUIDITY_PROVIDER_ADDRESS then 'unstakers that create liquidity' else 'unstakers that not create liquidity' end as activity
from osmosis.core.fact_staking a join osmosis.core.fact_liquidity_provider_actions b
where a.block_timestamp>= '2022-01-01'
and b.block_timestamp>= '2022-01-01'
and a.ACTION ='undelegate'
and b.ACTION='pool_joined'
and b.TX_STATUS='SUCCEEDED'
and b.CURRENCY ='uosmo'
group by activity