ngxuan885Sushi Reward Program for Farmers: total or partial
Updated 2022-05-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with rewards as (SELECT TO_ADDRESS, sum(AMOUNT) as rec_amount
FROM ethereum_core.ez_token_transfers
where BLOCK_TIMESTAMP::date >= '2021-10-22'
and SYMBOL = 'SUSHI'
and FROM_ADDRESS = '0x1026cbed7b7e851426b959bc69dcc1bf5876512d' GROUP by 1),
a as (
SELECT address, rec_amount , amount
from ethereum_sushi.dim_distributor_reward_schedule e
left JOIN rewards on lower(rewards.to_address) = lower(e.address)
where REWARDS_SNAPSHOT = '2021-10-22 23:10:00.000'
and MERKLE_ROOT = '0x015e6c2cd1a4d6fa77aa1884c436b2435aae4beab5c9a091f18fd0c00dc7e577')
SELECT case when REC_AMOUNT is null THEN 'no reward'
when REC_AMOUNT = amount THEN 'fully claimed'
when REC_AMOUNT <> amount THEN 'partially claimed'
end as wallets,
count(*) as numbers
from a GROUP by 1
Run a query to Download Data