strawbettyDifferent percentages of rewards
Updated 2022-05-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
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