select

count (DISTINCT FROM_ADDRESS) as num_users

from thorchain.liquidity_actions

),

transfers as (

select

count (DISTINCT FROM_ADDRESS) as num_users

from flipside_prod_db.thorchain.transfers

where from_address not in (select distinct from_address from thorchain.liquidity_actions)

),

ALL_users as (

select ( liquidity.num_users + transfers. num_users) as num_users from liquidity , transfers

),

Lpers as (

select

from_address as wallet,

sum (iff(lp_action = 'add_liquidity',rune_amount , -rune_amount ) ) as sum_rune_amount

from thorchain.liquidity_actions

where lp_action in ('add_liquidity' ,'remove_liquidity')

and rune_amount > 0

and rune_amount is not null

and tx_id is not NULL

group by 1

select 'have open LP position' as type , count (wallet) as num_users from Lpers group by 1

UNION select 'NOT have open LP position' as type , num_users from ALL_users