cypherNEAR - 9. Developer Activity - developers by category
Updated 2023-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with commits as (select
author,
count(*) as n_commits
from near.beta.github_activity
where author not in ('dependabot', 'dependabot-preview')
group by author),
one_commit_devs as (select
author
from commits
where n_commits = 1
),
small_devs as (select
author
from commits
where n_commits > 1
and n_commits <= 100),
medium_devs as (select
author
from commits
where n_commits > 100
and n_commits <= 500),
big_devs as (select
author
from commits
where n_commits > 500)
select count(*) as n, 'a. 1-commit' as label from one_commit_devs
union
select count(*) as n, 'b. small devs (1-100)' as label from small_devs
union
select count(*) as n, 'c. medium devs (100-500)' as label from medium_devs
Run a query to Download Data