248699::numeric as number_eligible_users,

count (distinct event_inputs:recipient) as number_claimers,

sum (event_inputs:amount/1e18) as claimed_amount, claimed_amount/number_claimers as avg_amount_per_claimer,

(number_claimers/number_eligible_users)*100 as claimers_percentage,

(claimed_amount/airdrop_amount)*100 as claimed_amount_percentage,

number_eligible_users - number_claimers as number_unclaimed_users,

airdrop_amount - claimed_amount as unclaimed_amount

from optimism.core.fact_event_logs

where event_name ilike 'Claimed' and origin_to_address ilike '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'

and origin_function_signature ilike '0x2e7ba6ef'

and block_timestamp <= current_date - 1