with withdrawers as (select
to_address,
il_protection
from thorchain.liquidity_actions
where lp_action = 'remove_liquidity')
select
case
when il_protection = 0 then 'No IL PROTECTION'
when il_protection > 0 then 'Have IL PROTECTION '
end as category,
count(distinct to_address) as NoOfUsers
from withdrawers
group by 1