select delegator

,tx_hash

,block_timestamp as t

from optimism.core.fact_delegations

where delegation_type = 'First Time Delegator'

)

,b as (select origin_from_address as wallet_address

,block_timestamp as t

,tx_hash

,event_inputs:amount/10e17 as OP_claimed

from optimism.core.fact_event_logs

where event_name = 'Claimed'

and contract_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de')

,c as (select wallet_address

,delegator

,case when delegator is null then 'Never Delegates OP' when delegator is not null then 'Delegated OP' end as status

from a right join b on b.wallet_address=a.delegator)

select status, count(distinct wallet_address) as "number of wallets"

from c group by 1