SELECT event_inputs:recipient as claimer,

min(block_timestamp) as claim_time,

sum(event_inputs:amount/pow(10,18)) as claim_amount

FROM optimism.core.fact_event_logs

WHERE origin_to_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de' AND event_name = 'Claimed'

GROUP BY 1

SELECT

delegation_type,

COUNT(DISTINCT b.claimer)

FROM optimism.core.fact_delegations as a JOIN claimers_list as b

ON a.delegator = b.claimer AND a.block_timestamp > b.claim_time

WHERE status = 'SUCCESS'

GROUP BY 1