from thorchain.liquidity_actions

where lp_action = 'add_liquidity'

group by 1),

remlp as (select pool_name, count (distinct from_address) as address_remove

from thorchain.liquidity_actions

where lp_action = 'remove_liquidity'

group by 1)

select a.pool_name, a.address_add, b.address_remove,

case when b.address_remove is null then '0' else b.address_remove end as address_removed,

((address_removed/address_add)*100) as remove_percentage

from addlp a

left outer join remlp b on a.pool_name = b.pool_name

order by 5 desc