ngxuan885Sushi Reward Program for Farmers: total or partial
    Updated 2022-05-07
    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