block_timestamp,

-- project_name,

label_type,

from_address,

FROM avalanche.core.fact_transactions a

JOIN avalanche.core.dim_labels b on a.to_address=b.address

block_timestamp::date >= current_date - 31

and LABEL_TYPE not in ('cex','token','chadmin','operator','token_contract')

and STATUS = 'SUCCESS'

),

new_user AS (

SELECT

from_address,

MIN(block_timestamp) AS min_date

FROM

avalanche.core.fact_transactions

GROUP BY 1

having min_date >= current_date - 31

select label_type,

case when from_address in (select from_address from new_user)

then 'New Users' else 'Old Users' end as type,

count(DISTINCT from_address) AS total_users

from tbl1

group by 1,2

order by 3 desc