rajs# of Days Active 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
›
⌄
SELECT
date,
avg(no_of_days) as avg_no_of_days,
median(no_of_days) as median_no_of_days,
percentile_cont(0.2) within group (order by no_of_days) as "bottom_20_pct",
percentile_cont(0.4) within group (order by no_of_days) as "bottom_40_pct",
percentile_cont(0.6) within group (order by no_of_days) as "top_40_pct",
percentile_cont(0.8) within group (order by no_of_days) as "top_20_pct"
FROM
(
SELECT
date_trunc('month', updatedat) as date,
author,
count(distinct date_trunc('day', updatedat)) as no_of_days
from near.beta.github_activity
group by 1,2
)
group by 1
order by 1
Run a query to Download Data