0xaimanANC reward Claimer Staking Position
    Updated 2022-02-05
    select st_pos as staking_position, count(sender) as n_user from
    (select case when a>1 then 'Added ANC on top of Reward for Staking' else 'Use solely ANC reward for staking' end as St_pos,
    case when b>1 then 'Added ANC on top of Reward for LP' else 'Use solely ANC reward for LP' end as lp,
    sender
    from (with data1 as (with rc as (select sender, sum(CLAIM_0_AMOUNT) as staking_reward, sum(CLAIM_1_AMOUNT) as borrow_reward
    from anchor.reward_claims

    group by 1
    ),


    st as (select sender, sum(amount) as ANC_staked
    from anchor.gov_staking
    where event_type='stake'
    group by 1 )

    select rc.sender, staking_reward+borrow_reward as tot_ANC_reward, ANC_staked
    from rc inner join st on st.sender=rc.sender

    ),

    data2 as (

    select msg_value:sender as sender, sum(msg_value:execute_msg:provide_liquidity:assets[0]:amount/1000000) as ANC_lp
    from terra.msgs
    where --tx_id='426494A85E93D782A85F8265B80B17B972D3212E0B21947EFEC4E7AADFC778F2' and
    msg_value:execute_msg:provide_liquidity:assets[0]:info:token:contract_addr='terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76'
    group by 1
    )

    select data2.sender,TOT_ANC_REWARD, ANC_STAKED, ANC_lp, (ANC_STAKED/TOT_ANC_REWARD) as a, (ANC_lp/TOT_ANC_REWARD) as b
    from data1
    inner join data2 on data1.sender=data2.sender))
    group by 1 order by 1


    Run a query to Download Data