RamaharIL protection
    Updated 2022-04-14
    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

    Run a query to Download Data