strawbettyDifferent percentages of rewards
    Updated 2022-05-09
    with table1 as (select lower(address) as eligible_address,
    amount as reward_amount
    from ethereum_sushi.dim_distributor_reward_schedule
    where MERKLE_ROOT = '0x015e6c2cd1a4d6fa77aa1884c436b2435aae4beab5c9a091f18fd0c00dc7e577'
    ),
    claimed_reward as (
    select
    lower(to_address) as claimed_address,
    sum(amount) as claimed_amount
    from ethereum_core.ez_token_transfers
    where from_address = '0x1026cbed7b7e851426b959bc69dcc1bf5876512d'
    group by 1
    ),
    partially_claimed as (
    select
    eligible_address as partially_claimed_address
    from table1 e inner join claimed_reward c on e.eligible_address = c.claimed_address
    and reward_amount > claimed_amount
    )

    select
    count(distinct eligible_address) as total_eligibled,
    count(distinct claimed_address) as total_claimed,
    count(DISTINCT partially_claimed_address) as partially_claimed_addresses,
    partially_claimed_addresses/total_eligibled * 100 as partially_claimed_percetange,
    total_eligibled-total_claimed as total_not_claimed,
    total_not_claimed/total_eligibled * 100 as not_claimed_percentage,
    total_claimed/total_eligibled * 100 as claimed_percentage
    from table1, claimed_reward,partially_claimed

    Run a query to Download Data