rajs# of Actions By Developer Category
Updated 2023-01-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
date,
avg(no_of_actions) as avg_no_of_actions,
median(no_of_actions) as median_no_of_actions,
percentile_cont(0.2) within group (order by no_of_actions) as "bottom_20_pct",
percentile_cont(0.4) within group (order by no_of_actions) as "bottom_40_pct",
percentile_cont(0.6) within group (order by no_of_actions) as "top_40_pct",
-- percentile_cont(0.2) within group (order by no_of_actions) as "60-80_pct",
percentile_cont(0.8) within group (order by no_of_actions) as "top_20_pct"
FROM
(
SELECT
date_trunc('month', updatedat) as date,
author,
count(*) as no_of_actions
from near.beta.github_activity
group by 1,2
)
group by 1
order by 1
Run a query to Download Data