with t1 as (
select
lower(address) as eligible
from ethereum_sushi.dim_distributor_reward_schedule
where MERKLE_ROOT = '0x015e6c2cd1a4d6fa77aa1884c436b2435aae4beab5c9a091f18fd0c00dc7e577'
and REWARDS_SNAPSHOT::date = '2021-10-22'
), active_wallet as (
select
distinct(lower(FROM_ADDRESS)) as active_address
from ethereum_core.fact_transactions
where active_address IN (select * from t1)
and block_timestamp >= CURRENT_DATE - 90
)
select
count(DISTINCT active_address) as eligible_active_address,
count(DISTINCT eligible) as eligible_ad,
eligible_ad-eligible_active_address as dead_address,
dead_address/ eligible_ad * 100 as dead_percetange
from active_wallet, t1