with airdropt as (

select block_timestamp,

origin_from_address as receiver,

tx_hash,

event_inputs:value/1e18 as Volume

from ethereum.core.fact_event_logs

where origin_to_address = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'

and event_name = 'Transfer'

and origin_function_signature = '0x48c54b9d'

and tx_status = 'SUCCESS'),

actiontable as (

select t1.block_timestamp,

origin_from_address,

t1.tx_hash,

from ethereum.core.fact_event_logs t1 join airdropt t2 on t1.origin_from_address = t2.receiver and t1.block_timestamp > t2.block_timestamp

where contract_address = '0x4d224452801aced8b2f0aebe155379bb5d594381')

select case when receiver in (select origin_from_address from actiontable) then 'Sold $APE'

else 'Still holding $APE' end as type,

count (distinct receiver) as users_count

from airdropt

group by 1