Moennnrrrprr
Updated 2023-01-27Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
count(distinct case when CLOSEDAT is null then id end) as n_open_prs,
count(distinct case when CLOSEDAT is not null then id end) as n_closed_prs,
n_open_prs + n_closed_prs as tot_prs,
100 * n_open_prs / tot_prs as open_pr_ratio,
100 * n_closed_prs / tot_prs as closed_pr_ratio,
tot_prs / count(distinct author) as opened_pr_p_dev,
n_closed_prs / count(distinct author) as closed_pr_p_dev
from near.beta.github_activity
Run a query to Download Data