count(distinct from_address) as active_users

,count(case when nonce=0 then from_address else null end) as new_users

,count(distinct case when to_address is null then from_address else null end) as devs

from ronin.core.fact_transactions

where 1=1

and date_trunc('month',block_timestamp)='2025-02-01'