select action,
count(distinct TX_ID) number_of_transactions,
count(distinct liquidity_provider_address) as number_of_liquidity_providers
from osmosis.core.fact_liquidity_provider_actions
where pool_id[0] = '773' and tx_status = 'SUCCEEDED'
and action in ('pool_joined', 'pool_exited')
group by 1