date_trunc('month', createdat) as date,

count(distinct(author)) as unique_developers

from near.beta.github_activity

group by date),

first_app as (select

author,

min(createdat) as first_commit

from near.beta.github_activity

group by author

),

monthly_new_dev as (select

date_trunc('month', first_commit) as date,

count(*) as new_dev

from first_app

group by date

select *, from monthly_active a

join monthly_new_dev n using (date)