with airdropt as (
select block_timestamp as receive_date,
origin_from_address as receiver,
event_inputs:value/1e18 as received_volume
from ethereum.core.fact_event_logs
where origin_to_address = '0xf2d15c0a89428c9251d71a0e29b39ff1e86bce25' -- Blur Airdrop Contract
and contract_address = '0x5283d291dbcf85356a21ba090e6db59121208b44' --Blur Token
and origin_function_signature = '0x3d13f874' -- Claim
and event_name = 'Transfer'
and tx_status = 'SUCCESS'),
actiontable as (
select t1.block_timestamp,
origin_from_address,
t1.tx_hash,
contract_address
from ethereum.core.fact_event_logs t1 join airdropt t2 on t1.origin_from_address = t2.receiver and t1.block_timestamp > t2.receive_date
where contract_address = '0x5283d291dbcf85356a21ba090e6db59121208b44')
select case when receiver in (select origin_from_address from actiontable) then 'Not Holding (Spent) Airdropped $BLUR'
else 'Holding Their Airdropped $BLUR' end as type,
count (distinct receiver) as users_count
from airdropt
group by 1