select

SENDER_ADDRESS as TX_SIGNER,

min(date_trunc('month', created_at)) over (partition by TX_SIGNER) as signup_date,

date_trunc('month', created_at) as activity_date,

datediff('month', signup_date, activity_date) as difference

from axelar.axelscan.fact_transfers

where status='executed' AND SIMPLIFIED_STATUS='received' and link is not null and SEND_AMOUNT_RECEIVED is not null

and send_fee is not null and destination_chain is not null) ,

unp as (

select

TO_VARCHAR(signup_date, 'yyyy-MM') as cohort_date,

difference as months,

count (distinct TX_SIGNER) as users

from

base

where

datediff('month', signup_date, current_date()) <= 12

group by

1,2

order by

1

),

fine as (

select

u.*,

p.USERS as user0

from

unp u

left join unp p on u.COHORT_DATE = p.COHORT_DATE

where

p.MONTHS = 0

COHORT_DATE,

MONTHS,