, Exited_sum - Joined_sum

select liquidity_provider_address as address

, count(case when action = 'pool_joined' then 1 else null end) as Joined_count

, count(case when action = 'pool_exited' then 1 else null end) as Exited_count

, sum(case when action = 'pool_joined' then amount else 0 end) as Joined_sum

, sum(case when action = 'pool_exited' then amount else 0 end) as Exited_sum

from osmosis.core.fact_liquidity_provider_actions

where block_timestamp::date = '2022-06-08'

and action in ('pool_exited','pool_joined')

group by address

) osmos

where osmos.Joined_count > 20

and osmos.Exited_count > 20

order by osmos.Joined_count desc

, osmos.Exited_count desc