author,

count(*) as n_commits

from near.beta.github_activity

where author not in ('dependabot', 'dependabot-preview')

group by author),

one_commits as (select * from commits

where n_commits = 1)

select

date_trunc('month', createdat) as date,

count(*) as n_one_commiters

from near.beta.github_activity

where author in (select author from one_commits)

group by date