WITH all_delegations AS

(SELECT *

FROM arbitrum.core.ez_decoded_event_logs

WHERE contract_address = '0x912ce59144191c1204e64559fe8253a0e49e6548'

AND event_name = 'DelegateChanged'

AND tx_status = 'SUCCESS'),

all_airdrop_claims AS

(SELECT *,

WHEN tx_hash IN (SELECT tx_hash FROM all_delegations) THEN 'Claimed And Delegated'

ELSE 'Claimed Only'

END) AS claim_type

FROM arbitrum.core.ez_decoded_event_logs

WHERE contract_address = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'

AND event_name = 'HasClaimed'

AND tx_status = 'SUCCESS'),

users AS

(SELECT DISTINCT (date_trunc('month',block_timestamp)) AS active_period

,from_address AS address

FROM arbitrum.core.fact_transactions

WHERE BLOCK_TIMESTAMP::date >= CURRENT_DATE() -INTERVAL '7 months'

AND from_address IN (SELECT ORIGIN_FROM_ADDRESS FROM all_airdrop_claims)

),

initial_cohorts AS (

SELECT address,

MIN(active_period) AS initial_period

FROM users

GROUP BY address

),

cohort_diff AS (