with receivers as ( SELECT to_address as claimers
FROM ethereum_core.ez_token_transfers
where BLOCK_TIMESTAMP::date >= '2021-10-22'
and SYMBOL = 'SUSHI'
and FROM_ADDRESS = '0x1026cbed7b7e851426b959bc69dcc1bf5876512d' )
SELECT case
when lower(ADDRESS) in (SELECT lower(claimers) from receivers) THEN 'received reward'
else 'no' end as address, count(*) as numbers
from ethereum_sushi.dim_distributor_reward_schedule
where REWARDS_SNAPSHOT = '2021-10-22 23:10:00.000'
and MERKLE_ROOT = '0x015e6c2cd1a4d6fa77aa1884c436b2435aae4beab5c9a091f18fd0c00dc7e577'
GROUP by 1